Query on Exceptions

[Former Member]

Hi ,

I have two columns(key figs) called actual and plan. I have to write an exception such that those Actual values are highlighted which are less than the corresponding plan values.How do i do it?

I tried creating a fromula which was the difference of the two but since the exception was based on the difference only the difference column gets highlighted.but i want deviation in the actual column to be highlighted.

Help would be appreciated

Regards

Ravi

[former_member188975 · Accepted solution]

Hi Ravi,

If this is for a web report there may be a possible solution as described here:

Hope this helps...

[Former Member]

Cant this be done using exceptions only? is it necessary to write a VB script?

[Former Member]

Hi,

Try with some logic with CKF. I think that can be done with CKF. Will get back to you once I get a solution. Meanwhile try to give some info which can give better idea.