Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Plan | Place | Activity | # Cards | Flag_Act Finished |
---|---|---|---|---|
L1 | DF | A1 | 1000 | 1 |
L1 | DF | A1 | 1500 | 1 |
L1 | DF | A1 | 1100 | 1 |
L2 | DF | A1 | 1001 | 0 |
L2 | DF | A2 | 1002 | 1 |
L2 | DF | A2 | 1526 | 1 |
L2 | DF | A2 | 1452 | 1 |
L2 | CD | A3 | 1895 | 1 |
L3 | CD | A3 | 2411 | 0 |
L3 | CD | A3 | 2633 | 0 |
L3 | CD | A4 | 1102 | 1 |
L4 | CD | A4 | 1103 | 1 |
L4 | CD | A4 | 1204 | 1 |
L4 | CD | A4 | 1225 | 1 |
L4 | CD | A4 | 1365 | 1 |
You could try something like
=sum(aggr( if(sum([Flag_Act Finished])=count([Flag_Act Finished]),1,0), Plan))
Check for each Plan ( L1 to L4 ), if sum of flag equals the count (if there is any zero flag, there will be a difference).
You could try something like
=sum(aggr( if(sum([Flag_Act Finished])=count([Flag_Act Finished]),1,0), Plan))
Check for each Plan ( L1 to L4 ), if sum of flag equals the count (if there is any zero flag, there will be a difference).
That was quick, A lots of thanks, so simple and I didn't think about it.