Skip to Content
0
Jul 27, 2016 at 04:04 PM

NumberVar Question

35 Views

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