Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Can you provide some more detail? From your message, I did not understand exactly what you are trying to do.
Cloud or On-Prem?
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.
Hi @David_Friend it is On-Prem.
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.