Hello,
I have this table : (exemple )
| SEGMENT | ID | LIMITE_CIBLAGE | LIMITE_AOUT | CLIENTS_CIBLAGE | NBR_CLIENT
| TX |
|---|
| | | | 4 | | 1 | 25,000% |
| X | 63794 | 2000,0 | 2000,0 | 1 | 0 | 0,000% |
| X | 69064 | 2000,0 | 2000,0 | 1 | 0 | 0,000% |
| X | 75092 | 2000,0 | 2000,0 | 1 | 0 | 0,000% |
| X | 87401 | 0,0 | 33.5 | 1 | 1 | 100,000% |
| .... | | | | | | |
NBR_CLIENT=if(LIMITE_AOUT<>LIMITE_CIBLAGE, 1,0)
I have 5 segments, if I choose the first one, I got 0.001%, or my expresion is NBR_CLIENT/CLIENTS_CIBLAGE should give me 2.1%
I tried for the others, it is the same problem, or for the SEGMENT = X , I got the right result.
For segment Y for exemple: I have NBR_CLIENT=1600 and CLIENT_CIBLAGE = 5700.
I can't find what is the problem. any help please?
thanks.
