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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress Zero Values

Status
Not open for further replies.
Oct 23, 2007
36
US
I have a report where I want to hide/delete a rows if the budget and Actual values are equal to 0 for an item.

I tried several things including creating a field where I said
if bugdet <> 0 and actual <> 0 then item

but it only hides the value for the item and shows everything else.

I am stuck, please help!

 
Go to section expert ----> suppress -----> x+2
write
not(bugdet = 0
and actual = 0)

this should work

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top