I have a simple query with two key figures.
I want Actual to be Red when is less than Budget.
I created a formula:
- ActualVsBudget = Actual - Budget
I created an exception on ActualVsBudget < 0
Data Cell affects Actual.
1. In Query Analyzer only ActualVsBudget gets colored (insted of Actual).
2. In Web it works fine, but as soon as I hide column ActualVsBudget (color doesnt work anymore).
Please tell me what am I doing wrong. This is a basic feauture in reporting, I guess SAP must be aware if it is a bug, but I havent find any note about this.
While creating exceptions, you can choose the elements that need to be highlighed, I believe.
Regarding the problem with hiding the column, this is how exceptions behave when the column on which they are created is hidden in the query designer. What you can do here is to create a custom web template for the query, and in the properties of the analysis item (which you'll use to display the query), you can specify the range of columns you want to display from the query. Leave out the column on which exception is created. The exception will continue to work in this case.
Hope this helps.