Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)))
@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)))