Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The formula is as follows, Stores that meet either SO_Qty>0 or SOH_Qty>0 are counted:
count(distinct AGGR(IF(SUM(SO_Qty)>0 or SUM(SOH_Qty)>0,Store_Name,),Store_Name))
Are there other formulas that can be written without the aggr function?
Hi @Nora104 ,
Try like below
=Count({<StoreName= {"=SUM(SO_Qty)>0 or SUM(SOH_Qty)>0"}>}DISTINCT StoreName)
and also, you can reduce your formula like below
Sum(AGGR(IF(SUM(SO_Qty)>0 or SUM(SOH_Qty)>0,1),Store_Name))
Hi @Nora104 ,
Try like below
=Count({<StoreName= {"=SUM(SO_Qty)>0 or SUM(SOH_Qty)>0"}>}DISTINCT StoreName)
and also, you can reduce your formula like below
Sum(AGGR(IF(SUM(SO_Qty)>0 or SUM(SOH_Qty)>0,1),Store_Name))