Hello Experts,
In my requirement, i have displayed packed fields upto 2 decimal places in a column for showing the amounts.
So when the amount is Rs.150 , it gets displayed as 150.00
For the amount of Rs.0, it gets displayed as 0.00
I want for amounts as null(0); the value displayed in the cell should be blank and not 0.00.
I cannot change the datatype to char as I want totals and subtotals to be calculated for them. Is there any way by which i can display the null values as blank and not as 0.00?
Regards,
Mansi.