Solved calculated field based on checkbox in report

[M Costumes]

I'm working on a report and am creating some calculated text fields. I have a checkbox, and if it is checked, I want it to calculate a value, and if unchecked return 0.

Basically I'm trying to get:
if checkbox = true, then count[field]*15
if checkbox = false, then 0

I'm very new and am still trying to grasp IIF statements, and am having trouble getting the right syntax. Thanks for your guidance!

 

[theDBguy]

Hi. Try using an IIf() statement. For example:

=IIf([Checkbox]=True,Count([Field])*15,0)

 

[M Costumes]

Hi. Try using an IIf() statement. For example:

=IIf([Checkbox]=True,Count([Field])*15,0)

Success! Thank you! I was missing and/or adding extra parentheses. Weeeee!

 

[theDBguy]

Success! Thank you! I was missing and/or adding extra parentheses. Weeeee!

You're welcome. Glad to hear you got it sorted out. Good luck with your project.