set analysis

[Anonymous]

Dear all,

is there anyone who can put me on the right track ?

I don't know how to solve the folowinf problem:

I would count all the supplier with purchase value = 0

=count({<VALUE = {"=sum({<VALUE = {0}>} VALUE)> 0"}>} distinct SUPPLIER)

In the excel file all the supplier data

Help please , I'm making crazy

[#2]

Hi,

Try with this expression..

Count({$<VALUE = {0} >} Distinct SUPPLIER)

Note: For optimization point of distinct count not recommended.

Karthik

[perumal_41]

use this expression

count({<SUPPLIER= {"=sum({<VALUE = {0}>} VALUE)> 0"}>} distinct SUPPLIER)