I have created a joined report that shows a percentage formula. It is working fine when the percentage is less than 100, but if it is more than 100 (i.e. a target has been exceeded) it reverses the formula.
example: target is 2, acheived 4, % showing is 50% rather than 200%.
Any ideas would be welcome! Thanks!
9 respostas
Hi Steve - please see below. Yes I am using a custom summary formula. Thanks so much!
