Exclude 0

[devarasu07]

Hi All,

Please refer to the attachment, how to apply below Product condition into Grade expression

Product:

=if(aggr(sum(QtySold),Product) <>0  and aggr(sum(Sales),Product)<>0,Product)

Grade:

=aggr(if( rangesum(above(TOTAL (Sum({<Product>} Sales)/Sum(TOTAL {<Product>} Sales)),0,RowNo(Total)))<=0.6,'A Stocks',if(

  rangesum(above(TOTAL (Sum({<Product>}Sales)/Sum(TOTAL {<Product>} Sales)),0,RowNo(Total)))>0.6 and rangesum(above(TOTAL (Sum({<Product>} Sales)/Sum(TOTAL {<Product>} Sales)),0,RowNo(Total)))<=0.9,'B Stocks',

  'C Stocks'

  )

  ),Product)

Note: my case i can't use suppress 0 value (Presentation tab because summary report won't work)

Thank,Dev

[lironbaram · Accepted solution]

hi

have a look at the example ,

i changed the dimension in the summary table

and checked suppress null values