Conditional Formatting issue
I have a report in AAO based on a BEx query.
1 of the columns is a calculated key figure coming from the BEx query.
The total line of this column is changed from Default to Sum (because the total cannot be calculated with this formula but it should be the sum of all calculated values).
I have now added a conditional formatting on this column but due to the changes in the total line the formatting is not correct for this line - I suppose the formatting is based on the calculation and not on the Sum I see).
How can this be solved?