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 derfloh 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.
Joined
Oct 23, 2007
Messages
36
Location
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