Need to Calculate Text count

[stou]

HI ,

Please refer the below Snap shot . I need the help to calculate 'Active' Count from the expression field.

Can anybody solve this problem.

Sub Dealer Name	Active Count-22
Enterprises	1
Vision Limited	Active
Vision Punpun	3
Electricals	0
Hardware	2
Sale	6
Electronics	7
Ganesh Enterprises	5

[igoralcantara]

Can you provide some more detail? From your message, I did not understand exactly what you are trying to do.

[David_Friend]

Cloud or On-Prem?

[stou]

Hi @igoralcantara this is the expression have written to get that count

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

but i need to calculate what is  the count of 'active' from the above expression. 

[stou]

Hi @David_Friend  it is On-Prem.

[igoralcantara]

I believe that what is not clear to me is what is 'active'? Which of those rows do you want to count? The layout of that table does not tell me that.