Display of exceptions in WAD
I have been using WAD to generate templates that we are using to broadcast to PDF. A recent requirement is for a report that uses exceptions to highlight performance against target.
The keyfigures are set in triples: Result - Target - Variance. The exceptions are set based on the Variance but to display on the Result.
Example, Result 100 - Target 100 - Variance 100% will display the Result value as Good.
However the user/client only wants to see the Result column and not the Variance. If I hide the Variance in the base query I loose the exception display completely.
How can I get this to work?