Suppressing 1

[parsnipdigdug]

I have a Group Footer section that I want to supress if 2 of the six columns are equal zero. There may be data in the other 4 columns

 

[GJParker]

Try this as the suppression fromula for your section

local numbervar suppress

If column1 = 0 Then Suppress :=1;
if column2 = 0 then Suppress := Suppress + 1;
if column3 = 0 then Suppress := Suppress + 1;
if column4 = 0 then Suppress := Suppress + 1;
if column5 = 0 then Suppress := Suppress + 1;
if column6 = 0 then Suppress := Suppress + 1;

Suppress > 1

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[parsnipdigdug]

Thanks for your help Gary !