Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
LINE | TOTAL COUNT | OVER COUNT | OVER COUNT RATIO |
A | 800 | 190 | 23.8% |
741 | 236 | 31.8% | |
726 | 224 | 30.9% | |
731 | 261 | 35.7% | |
723 | 217 | 30.0% | |
716 | 22 | 3.1% |
I want to add the "MAX COUNT CHECK" item to the above table.
LINE | TOTAL COUNT | OVER COUNT | OVER COUNT RATIO | MAX COUNT CHECK |
A | 800 | 190 | 23.8% | |
741 | 236 | 31.8% | ||
726 | 224 | 30.9% | ||
731 | 261 | 35.7% | V | |
723 | 217 | 30.0% | ||
716 | 22 | 3.1% |
This is the table I want.
So i wrote this but it didn't work.
=if(LINE='A' AND MAX(COUNT(OVER COUNT)/COUNT(TOTAL COUNT)), V, NULL()) as MAX COUNT CHECK
Please let me know how to solve it.
Thank you.
Hi
You will need to look at the AGGR Function. What is the Dimensional split of that table? then you will want something like this
IF ( MAX(AGGR(COUNT(OVER COUNT)/COUNT(TOTAL COUNT)),Dimension) = COUNT(OVER COUNT)/COUNT(TOTAL COUNT), 'V')