when using formula "if is null" sometimes works sometimes doesnt

[jizzycrystal]

if IsNull ({@period_amt}) then '0.00'
some fields I get 0.00 and other times just blank

 

[beltmanjr]

well, you must specify what to do if not null:

if IsNull ({@period_amt}) then
'0.00'
else
{@period_amt}

 

[LizSara]

what if the field was filled in and then deleted? It would no longer be null but would also be blank

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an abyss, the abyss will gaze back into you. ~ Nietzsche"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

[beltmanjr]

If the field would be deleted and not null, but simply empty, adjust the formula to

if (IsNull ({@period_amt}) or trim({@period_amt})='') then 
  '0.00'
else
  {@period_amt}

That should do

 

[dgillz]

Actually both the then and else values must be of the same data type. I somehow doubt that {@Period_amt} is a string.

Please post the formula for {@period_amt} so this question can be answered.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[jizzycrystal]

Thanks.....that worked!!