Count of Materials with sum greater then '0'in set analysis

[chaitanyajami]

Hi All,

I have requirement to show the count of Materials that have sum(Cost) value greater than '0', however the below expression which i have written is not working , please suggest how to achieve it.

if($(vLAVZC02Sum)>0,Count(Material))/Count(distinct Material)

vLAVZC02Sum = Sum({<Flag_LAV={'1'}>}Cost)

[sunny_talwar]

May be you need this

Count({<Material = {"=$(vLAVZC02Sum) > 0"}>}Material)

[Gabriel]

Hi,

Try this

Count({<Cost = {"=$(vLAVZC02Sum) > 0"}>}Material)

 Or as your expression was 

Count({<Cost = {"=$(vLAVZC02Sum) > 0"}>}Material)/Count(distinct Material)

Hope it helps