April 02, 2008, 10:20 AM
L_Gsuppress zeros in subfoot
Hi all,
I have report that prints totals in the subfoot section by using ST prefix. I need to hide the result of the sum if it is equal to zero.
Thanks in advance
April 02, 2008, 10:35 AM
Alan BYou could use RECAP, COMPUTE or DEFINE.
DEFINE FILE CAR
SALES/I8S =SALES;
END
TABLE FILE CAR
SUM SALES
COMPUTE SALE2/I8S=SALES;
BY COUNTRY
ON COUNTRY RECAP SALE1/I8S = C1;
ON COUNTRY SUBFOOT
"A<SALE1 B<ST.SALE2 C<ST.SALES"
END