AGGR

[Anonymous]

Hi

I have a situation where in have to sum up the quantity and count the batch but with the condition where sum of quantity<>0, please help. Data files attached herewith

Thanks in Advance

Vinayagam !

[stabben23]

Hi,

sum(aggr(if(SUM({<POSTINGNUM={"<=$(TEST)"}>}Quantity1_MSEG1)>0,COUNT(DISTINCT(BATCH)),0),BATCH))

[Anonymous]

thanks mate