Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am trying to count how many 1s are there for each value of column GSD_SA
I should get for X a value of 3
and I should get for Y a value of 6
I am using count({<UNDER_25={'1'}>} GSD_SA_ID) but I am getting a weird result. Ideas?
GSD_ACCT_ID GSD_SA_ID UNDER_25
1 | X | 0 |
1 | X | 0 |
1 | X | 1 |
1 | X | 1 |
1 | X | 1 |
1 | X | 0 |
1 | X | 0 |
1 | X | 0 |
1 | X | 0 |
1 | X | 0 |
1 | X | 0 |
1 | X | 0 |
1 | X | 0 |
2 | Y | 1 |
2 | Y | 1 |
2 | Y | 1 |
2 | Y | 1 |
2 | Y | 1 |
2 | Y | 0 |
2 | Y | 1 |
2 | Y | 0 |
2 | Y | 0 |
2 | Y | 0 |
Have you just tried Sum(UNDER_25)?