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...
ForrestParker
7 years agoQrew Cadet
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:
Try the following:
If
(
[Checkbox]=true AND [Field 1B]<>0
,[Field 1A]/[Field 1B]
)