Display of exceptions in WAD

[Former Member]

Hi Experts!

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?

[Former Member · Accepted solution]

Refer thread -

[Former Member · Accepted solution]

Many thanks for pointing me in the right direction.

A small change to the query structure and this solution works!

[Former Member]

You cannot hide Variance column.

but u can display only Result column with Green only.

Try option in keyfigure, hide can be shown..

hwo to define exception...?

create new exception

new, operator= greater than

value = 1

alert level = good1

In definition tab, use Keyfigures = Variance

In display tab, use Keyfigures -- Following structure element - RESULT.

HIt and save

run the query