HOW CAN I SUPRESS SUBTOTALS WHICH ARE ZERO

Focal Point

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

June 06, 2007, 07:17 AM

Shankar

HOW CAN I SUPRESS SUBTOTALS WHICH ARE ZERO

Hi,
How can i supress subtotals which are zero. I mean I would like to display blank space or a hyphen '-' in subtotals wherever its value is zero (or 0.00).
Please help.

Thanks,
Shankar

WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML

June 06, 2007, 07:28 AM

FrankDutch

Shankar

SALES/D12.2S .....
the S will supress all the zero values also in a total field.

An other solution is given in your other question.
You cam add a conditional styling and say if it is zero (0) than the color is white....

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

June 06, 2007, 07:35 AM

Shankar

Hi Frank,
The first solution itself is working so sweetely. I mean just using 'S' is supressing anything which is zero.
Thanks a ton. You are gr8. :-)
Shankar

WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML