Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to implement two conditions in set analysis as below,
=sum({<[Arrived Run Total]={">=0"} , [RunTot_Quantity]={"<0"}>} Quantity).
I need to sum all the quantities when the corresponding [Arrived_run Total] >=0 and [RunTot_Quantity]>0.
I'm trying to do it but unable to achieve the expected result.
I'm just able to add the quantities which has [Arrived Run Total] >=0 leaving out quantites which has [RunTot_quantity]>0.
Can someone help here?
Yes, I negative value sums are expected. With the above formula I can get positive value sums.