Forum Discussion

CourtneyRapp's avatar
CourtneyRapp
Qrew Cadet
7 years ago

calculating percentages based on checkboxes

I am looking for a way to calculate a percentage based on a checkbox and if a value exists for a specific field. So basically: If(([Checkbox]=true) & [Field 1B]=" ", [Field 1A]/[Field 1B],  ([Chec...
Formulas and functions
CourtneyRapp's avatar
CourtneyRapp
Qrew Cadet
7 years ago
So it is a numeric field, but the <>0 is not working? Here's how I entered:

If(([Checkbox]=true) & [Field 1B]<>0, [Field 1A]/[Field 1B]

I'm getting this error: 


Is there a way to do not Null? I tried just not IsNull and that didn't work either...
  • ForrestParker's avatar
    ForrestParker
    Qrew Cadet
    7 years ago
    I think that your issue is with the "&".  You use this to concatenate strings together.  To check two conditions you need to use "AND". 

    Try the following:

    If
    (
    [Checkbox]=true AND [Field 1B]<>0
    ,[Field 1A]/[Field 1B]
    ) 
  • EvanMartinez's avatar
    EvanMartinez
    Moderator
    7 years ago
    Forrest I think you hit the nail on the head. I glossed right over those ampersands when I was looking at the operators for the formula.