How Calculate the text Count within the formula

[stou]

Hi,

Please refer the formula, can anybody help me to calculate the text count in the below formula.

=if(Sum(Aggr(if(Sum(If(Year(smonth)='2022' ,Sale))>0,1,0),cat_,Quarter))=4,'Active',Sum(Aggr(if(Sum(If(Year(smonth)='2022' ,Sale))>0,1,0),cat_,Quarter)))

[stou]

@Anil_Babu_Samineni and @PrashantSangle  Can you help me on this

=if(Sum(Aggr(if(Sum(If(Year(smonth)='2022' ,Sale))>0,1,0),cat_,Quarter))=4,'Active',Sum(Aggr(if(Sum(If(Year(smonth)='2022' ,Sale))>0,1,0),cat_,Quarter)))