Help

If Statement w/ Checkbox & Sum

Topic Labels: Formulas
1575 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Lisa_H
6 - Interface Innovator
6 - Interface Innovator

Hi,
I’m trying to create a column that will calculate commission on the Sales Price of a job for me, but only if the Commission checkbox is checked. But I can’t get it to work!

Here is what I have:
IF({Commission?} = 1, SUM({Paid (Sold)})*.1 , 0)

What did I do wrong? All it returns are $0.00 even if I have a Checkbox marked!

Thank you for your help!

2 Replies 2

With many fields, including checkboxes, testing for the presence of any data (like a check mark) doesn’t require anything to compare against. Just put the field name by itself.

Also, you only have one field in the SUM function, so SUM isn’t really necessary.

What you’re left with is this:

IF({Commission?}, {Paid (Sold)} * .1 , 0)
Lisa_H
6 - Interface Innovator
6 - Interface Innovator

That worked!!! Thank you!