I am using this custom format to replace the missing values of a column with 0.00
On doing this the values 0.00 gets left aligned.
1. How to get them right aligned along with the other values.
2. Is there any other way by which we can replace the missing values with 0.00 and should appear as right aligned when used in proce report
Partly the answer depends on your destination of choice. You can use this syntax for RTF, PDF and HTML:
define sales / display format=abc.
but the downside is that this syntax won't work for LISTING.
One solution that would work for all destinations, including LISTING, would be to add a compute block to your code:
if sales = . then sales = 0.00;
*USAGE=SUM or default usage is used;
if sales.sum = . then sales.sum = 0.00;
If you need help faster than people on the forum respond, your best bet for a quick response is to contact Tech Support.