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...
Forum Discussion
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...
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]
)