I would like a default value to appear in a field where no actual value is returned in the report.
eg.
Field X Field Y Calc Field = X-Y
results eg.
10 5 5
12
11 11 0
There May actually be no result for Field Y and I would like "0" to appear so my calculation works, at the moment if there is nothing returned for Field Y, my Calc Field also returns nothing.
Thanks in adavnce for your help !
Regards,
Antoinette Crouch
eg.
Field X Field Y Calc Field = X-Y
results eg.
10 5 5
12
11 11 0
There May actually be no result for Field Y and I would like "0" to appear so my calculation works, at the moment if there is nothing returned for Field Y, my Calc Field also returns nothing.
Thanks in adavnce for your help !
Regards,
Antoinette Crouch