Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supress detail line if fields are zero 1

Status
Not open for further replies.

matahari

Programmer
Oct 16, 2000
32
CA
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):

Code:
GroupNumber > {?Top N} //This condition works ok
or
(Sum ({@Total Variance PRD}) = 0.0) //Can't get this condition to work



 
Try this in the same formula editor.

If SummarizedField = 0
Then True
Else False
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top