count over a sum within IF

[#1]

Hi All,

I want to calculate an expression for counting the distinct product ID where sum of quantity is 3.....

I am not able to write an expression for the same. Please help me with it.

Thanks

Arun

[Anonymous]

Hi,

Try:

=If((sum(Quantity)='3'),count(Distinct VENDOR_ID)) - For individual count

Or

=If((sum(Quantity)='3'),count(Total Distinct VENDOR_ID)) - For total count of all products

Regards

Neetha

[#3]

TRIED. But not working.

I took time ID as the dimension and expression stated by you in the above comment but not working.

[Anonymous]

Can you post the snapshot of the expression please.

Regards

Neetha

[#5]

Hi Arun,

Load * Inline [

Cat,ProdID,Qty

A,100,2

A,101,4

A,102,3

A,103,5

A,100,3

B,101,5

B,105,3

B,106,3];

Dim :                      Cat

Expression :        =count(if(aggr(sum(Qty),ProdID)=3,ProdID))

Thanks,

Prakash

[its_anandrjs]

Try this expression

=count(if( Quantity >= 3,  VENDOR_ID))

Regards

Anand

[anbu1984 · Accepted solution]

=Count(DISTINCT If(Aggr(Sum(Quantity),VENDOR_ID)=3,  VENDOR_ID))

[Anonymous]

See attached

[#9]

Thanks a lot. This expression is working fine.