How to "not show a value of zero in a row"?

[jack91]

hi,

I have 7 columns, with one column showing cost value of a product.

If the cost value in column 7 is 0, the user does not want to see it.Also user does not want to see any associated rows pertaining to the value 0.

How do i do this?

Thanks
Jk

 

[Turkbear]

Hi,
Eliminate it with a record selection formula:
Col7 <> 0





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jack91]

Just Col7 <> 0 -- is enough for deleting all the other rows also?

Do i need to use any parameters etc? or an if else statement?

THANKS
Jk

 

[Turkbear]

Hi,
Yes, as a record selection formula,
{table.column7} <> 0 ( use the real column name of course)
will only return records where that column's value is other than 0.



To Paraphrase:"The Help you get is proportional to the Help you give.."