Forum Discussion
ShontaySmith
Qrew Assistant Captain
Thanks, But I need to create an If Statement because I am seeing "0" if the number is blank. And if I add the following I get an error missing brackets or etc
var text Num1 = If (not IsNull([Number1]), [Number1], "");
var text Num2 = If (not IsNull([Number2]), [Number2], "");
List(",", $Num1,$Num2)
var text Num1 = If (not IsNull([Number1]), [Number1], "");
var text Num2 = If (not IsNull([Number2]), [Number2], "");
List(",", $Num1,$Num2)
MCFNeil
8 years agoQrew Captain
You can do that, OR you can change the field properties for those fields.
There is a checkbox, that if the value is blank, it shows as "0" in calculations.
By default it is checked, just uncheck that box, then you wont have to do the 'IF' statements.
There is a checkbox, that if the value is blank, it shows as "0" in calculations.
By default it is checked, just uncheck that box, then you wont have to do the 'IF' statements.