Hi All,

I am having scenario like showing all subtotal values in subfoot.
I need is to supress subfoot line whenever subtotal value is zero. Here is sample code.

TABLE FILE TABLE1
COMPUTE TOTALSALE/D22.2= SALE1+ SALE2;NOPRINT
BY REGION
BY COUNTRY
ON REGION SUBFOOT
"Sale for Region ST.TOTALSALE"
ON COUNTRY SUBFOOT
"Sale for country ST.TOTALSALE"

ON TABLE PCHOLD FORMAT PDF
END

This message has been edited. Last edited by: FP Mod Chuck,

Check out the WHEN command.

Conditionally Displaying Summary Lines and Text

Thanks Waz... it will work I think..

Hi Waz,

I had same requirement with more than 12 computation elements which will be shown in subfoot.
In order to the supress subfoot line if the all the 12 values are zero do I need to write WHEN condition for all the field .
Is there any other alternate way to achieve it.

You can "write a WHEN condition for all the fields individually"
OR
You can create a COMPUTE which SUMs all fields and use that in your CONDITIONAL / WHEN Statement.

As Doug says, create a COMPUTE to build a flag for when to show/hide the subfoot

Thanks waz and doug its working..