I can’t seem to get boolean fields to work properly in formulas, I’ve tried everything I can think of in terms of how they might be stored and treated but nothing seems to work.
I simply want to perform a calculation if a boolean field is true, otherwise just return 0. I’ve tried the below but to no avail. Any help would be greatly appreciated!
IF(Boolean,Calculation,0) - Always returns Calculation
IF(Boolean=TRUE(),Calculation,0) - Never returns Calculation
IF(Boolean=1,Calculation,0) - Never returns Calculation