I have a column on a report that prints a letter for one condition, a number value for another condition and I want it to print 0.000 when the third condition applies. The report is not printing 0.000 when applicable. It is just blank.
Here's my formula for the column. There are no errors, but the 0.000 won't print. I have bolded the line of the condition that doesn't work.
Can someone show me what I'm doing wrong?
Thanks.
If isnull ({TRACKING_FILE.f7070#price_lock_exp_date}) then "F"
else
If not isnull ({TRACKING_FILE.f7070#price_lock_exp_date}) and ({TRACKING_FILE.Orig_Points} + {TRACKING_FILE.Disc_Points}) > 0 then
ToText ({TRACKING_FILE.Orig_Points} + {TRACKING_FILE.Disc_Points})
else
If not isnull ({TRACKING_FILE.f7070#price_lock_exp_date}) and ({TRACKING_FILE.Orig_Points} = 0) and ({TRACKING_FILE.Disc_Points} = 0) then "0.000"