Hello,
I have a formula and it work okay, but if the numbervar is blank I want to display a 0 and not a blank.
Here is the formula:
Shared NumberVar myTotal1:=Sum({SumFromStockData.Quanity});
I am using Shared because I have a sub report that I will be using this.
So I tried this:
if IsNull(myTotal1) then
0;
else
myTotal1;
The error comes up when I check it:
it highlights the first line for myTotal1 saying a Field is required here.
It might be a simply answer but I can't figure it out. Any help would be appreciated.
Thank you,
Gerald
Hi Gerald,
In the formula editor, look for an option on the top that says 'Exceptions for Nulls'; change that to 'Default Values for Nulls'.
Next, simply the change the formula to:
Shared NumberVar myTotal1:=Sum({SumFromStockData.Quanity});
-Abhilash
Add a comment