topic How Calculate the text Count within the formula in Data Movement & Streaming

How Calculate the text Count within the formula

stou — Wed, 19 Mar 2025 22:11:20 GMT

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

Re: How Calculate the text Count within the formula

stou — Fri, 05 Apr 2024 09:30:01 GMT

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