Forum Discussion
CourtneyRapp
7 years agoQrew Cadet
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...
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...
- ForrestParker7 years agoQrew CadetI 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]
) - EvanMartinez7 years agoModeratorForrest 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.