Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone, i need your wisdom, i have the following table:
Puesto | Menos de 3 meses | 3 a 6 meses | 6 a 12 meses | 1 a 2 años | 2 a 3 años | Mas de 3 años |
Chofer | 39 | 14 | 18 | 24 | 11 | 4 |
Gerente de Distrito | 2 | 1 | 4 | 6 | 3 | 3 |
Gerente de distrito en formacion | 0 | 1 | 0 | 0 | 0 | 0 |
Gestor Cobranza | 10 | 16 | 20 | 41 | 20 | 4 |
Gestor Ventas | 10 | 27 | 16 | 39 | 12 | 2 |
MGRNTRN | 4 | 5 | 2 | 1 | 0 | 0 |
MIT | 2 | 2 | 0 | 0 | 1 | 0 |
MSTRMGR | 12 | 3 | 13 | 42 | 18 | 15 |
Rep Cobranza | 91 | 60 | 69 | 49 | 14 | 1 |
Rep Ventas | 89 | 57 | 68 | 53 | 14 | 1 |
Total | 259 | 186 | 210 | 255 | 93 | 30 |
Total % | 25.07% | 18.01% | 20.33% | 24.69% | 9.00% | 2.90% |
I need to color the max value as green and the min value as red of each row, the problem is when i have two max values or two min values, in those situations it will not color, how can i color both or choose one to color? Any ideas?
Thanks!
When you have a tie, your > or < test will never be try. So change your operators to >= and <=.
Also, you could write more compact using RangeMax:
if(column(2) >= RangeMax(column(1), column(3),...)
Are you using a color expression? If so, can you post it?
-Rob
When you have a tie, your > or < test will never be try. So change your operators to >= and <=.
Also, you could write more compact using RangeMax:
if(column(2) >= RangeMax(column(1), column(3),...)