Can you use ""List"" for numeric fields
Can you help me with using "List" with numeric fields
Forum Discussion
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)
- 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.
