Forum Discussion
Set Target for Salesman
Need Measure of New Column formula to achieve Target Vs Actuals Collection Salesman Collection Target in % Collected Actual 1000 1 50 200 2000 2 65 100 3000 3 25 150 4000 ...
I need a Measure or Column to store my random target value given to Salesman
& collected acutals aginst the Target achieved
Hoping this is clear
| Collection as on 04-09-21 | Balance | Salesman | Collection Target in % (measure or column) | Collected Actual (output) |
| 04-09-2021 | 1000 | 1 | 50% | |
| 04-09-2021 | 2000 | 2 | 65% | |
| 04-09-2021 | 3000 | 3 | 25% | |
| 04-09-2021 | 4000 | 4 | 75% | |
| 04-09-2021 | 500 | 5 | 2% |
Eg: Salesman 1 must collect 50% of his balance amount that is 1000
what he acheived must be stored in the collected actuals output