Suppression of Records

[#1]

Hi All,

I have a straight table with 6 dimensions and 4 expression calculated field. one of these calculated expression fields is called Bales. I would like to suppress records on the basis of values in Bales field. If the value in the Bales field is 0, then I need that entire record to be suppressed. How can I achieve this.

Thank you

Herbert

[chiru_thota]

You can do one thing.For remaining three expression.You can write some thing like below and use second option in the below screen.

It will suppress the unnecessary records for you

If ( Sum(Bales) > 0,Sum(expression1),0)

If ( Sum(Bales) > 0,Sum(expression2),0)

[maxgro]

try with

for all (4) expression, set the expression to null when Bale is 0

Expression1          if(sum(Bale)=0,null(),sum(Expression1))

Expression2          if(sum(Bale)=0,null(),sum(Expression2))

....

....

and flag suppress 0 values in presentation tab