Can the formula (count when one of the conditions is met) not use the aggr function?

[Nora104]

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?

[MayilVahanan · Accepted solution]

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))