Report Formulas - Has anyone worked with checkboxes? - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Marsha SoeterikMarsha Soeterik 

Report Formulas - Has anyone worked with checkboxes?

I am creating reports & dashboards for upper management that requires I include all revenue in 1 dashboard component. Need to utilize check boxes in the criteria in report formulas since I can't bring in any other fields that are not considered "numeric" . It shows I can, supposedly, use the checkboxes; however, I need to know how to determine if it is true or false when it treats them as if they are amount fields. ISNULL & ISBLANK do not work since they are not empty & specifying that they = 0 or 1 for true or false respectively doesn't work either (downloaded into a Excel spreadsheet and found these are the values).  Our specialist sales reps are responsible for 1 - 5 different product types that have been broken down into individual amount fields.  

MULTIPLE AMOUNT FIELDS THAT MAY/MAY NOT BE ASSOCIATED WITH A SINGLE SALES REP.

EXAMPLE:
AMOUNT
AMOUNT1 CHECKBOX1
AMOUNT2 CHECKBOX2


IF CHECKBOX1 TRUE, AMOUNT + AMOUNT1, AMOUNT

IF ( AND (CHECKBOX1 FALSE, CHECKBOX2 FALSE), AMOUNT, (AMOUNT + AMOUNT1 + AMOUNT2)

& VARIATIONS TO THESE EXAMPLES...

Any ideas would be greatly appreciated!

Steve MolisSteve Molis
Are you trying to do this in a Report with a Custom Summary Formula (CSF) or with a Formula Field on the object? 

Can you post a screenshot of the report and create a mock-up of what you would like the result to look like?
Marsha SoeterikMarsha Soeterik
AFTER TAKING A BREAK AND COMING BACK TO THIS PROBLEM, I THINK I HAVE FIGURED OUT THE ANSWER.  THANK YOU FOR RESPONDING TO MY INITIAL REQUEST.