I have a problem supressing a Group Footer line if the a field in my Group Footer line is zero. Here's what I did:
In the FORMAT SECTION for the Group Footer - I added the following formula in the formula editor on the Suppress (No Drill-Down) line (I have the Suppress check box unchecked):
In the FORMAT SECTION for the Group Footer - I added the following formula in the formula editor on the Suppress (No Drill-Down) line (I have the Suppress check box unchecked):
Code:
GroupNumber > {?Top N} //This condition works ok
or
(Sum ({@Total Variance PRD}) = 0.0) //Can't get this condition to work