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
Hi Courtney,
Looking at this formula the second condition in your if is [Field 1B]=" " which would be if this checkbox is true and Field 1B is blank then divide Field 1A by Field 1B which would be blank and wouldn't return a value then. Should it instead be when Field 1B is not equal to blank or is not null?
Something like
If(([Checkbox]=true) & [Field 1B]<>0, [Field 1A]/[Field 1B],
([Checkbox]=true) & [Field 2B]<>0, [Field 2A]/[Field 2B],
([Checkbox]=true) & [Field 3B]<>0, [Field 3A]/[Field 3B]) . . . .
Looking at this formula the second condition in your if is [Field 1B]=" " which would be if this checkbox is true and Field 1B is blank then divide Field 1A by Field 1B which would be blank and wouldn't return a value then. Should it instead be when Field 1B is not equal to blank or is not null?
Something like
If(([Checkbox]=true) & [Field 1B]<>0, [Field 1A]/[Field 1B],
([Checkbox]=true) & [Field 2B]<>0, [Field 2A]/[Field 2B],
([Checkbox]=true) & [Field 3B]<>0, [Field 3A]/[Field 3B]) . . . .