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…