Focal Point
suppress zeros in subfoot

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6061067872

April 02, 2008, 10:20 AM
L_G
suppress 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


WebFOCUS 7.6
Windows 2000
Output: HTML, PDF
April 02, 2008, 10:35 AM
Alan B
You 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



Alan.
WF 7.705/8.007
April 02, 2008, 10:46 AM
L_G
Thanks, Alan B


WebFOCUS 7.6
Windows 2000
Output: HTML, PDF