function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
HNT_NeoHNT_Neo 

Power of 1 with a checkbox

Hello all!

I have a scenario where I want to use the Power of 1 functionality in a custsom object to count how many checkboxes are checked when i run a custom report. Any help on setting this up from A-Z is greately appreciated! Thanks in advance!

Custom Object Name: Atmosphere

Custom API Checkbox Field Name: Traveler

Best Answer chosen by HNT_Neo
Beth HowardBeth Howard
Hi!

If I understand your scenario correctly, you don't actually need the Power of 1 formula to do this in a report. Checkboxes can be added up with "Summarize this field" in reports because the checkbox values are stored as 1 (true/checked) and 0 (false/unchecked). In the report customization wizard, drag your checkbox field into the report layout. Click on the down arrow next to the field name, select "Summarize this field" and then check the "Sum" box. Click "Apply". That should do the trick.

Good luck!

Beth