Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Hi,
sum(aggr(if(SUM({<POSTINGNUM={"<=$(TEST)"}>}Quantity1_MSEG1)>0,COUNT(DISTINCT(BATCH)),0),BATCH))
thanks mate