Hi - have a dashboard in custom mode with a number of calculated fields.
- Stock committment rate % (calculated)
- Stock committment target % (from upload)
- Stock committment variance to target %(calculated)
I’m trying to add some logic in that says…
If stock committment variance to target is greater then 10%, then have another column that returns “Discount by 5%” or even “5”
This repeated… so if stock committment variance to target is greater then 20%, then returns “discount by 10%” or even “10”
I can’t work out the sql (if that’s the best way), or alternative ways to show the extra column… any help or suggestions very much appreciated…