Set Analysis

[#1]

Hi,

What is the best Set Analysis script to do a Count of Sum(Value)=0?

Rgards,

FLC

[ashfaq_haseeb · Accepted solution]

Try below

=Count({<Value={'0'}>}ID)

Regards

ASHFAQ

[#3]

Try this

Count({<Value={'0'}>} Fieldname)

[Gysbert_Wassenaar]

Perhaps this: count({<ID={'=sum(Value)=0'}>} distinct ID)

[#5]

Hi,

Thanks, I already tryed that but is not working for what I need.

Let me explain better:

Fields

StoreID ProductID Qt_Sold RowCounter [=1]

How Can I count the number of products per Stores with Sum(RowCounter)=0?

Regards,

FLC

[ashfaq_haseeb]

Hi,

Can you come up with sample data and expected o/p.

will RowCounter store 0 for not sold or what is the logic behind it?

Regards

ASHFAQ

[its_anandrjs]

What expression you use please provide that one.

Regards

Anand