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.