i have seen this happen when two different conditions specified are valid for same figure in the result.
e.g.. lets say my total result is 5 in the query
i have set 1-10 as green
4-6 as red
its going to apply both to my result as both are valid for 5 and resulting color is something like pink
hope you find it useful
regards
sharan
Thanks for the replies
I have already tried to solve the wrong colors exceptions with the format option in Bex but in this way the conditions imposed are not respected.
(for instance all the 350/400 results are in green or in red )
Regarding the second suggestion i must say that the range of conditions is correct but still the results colors are wrong.
In a previous project i applied in this case a custom vb macro but in this case this solution is not possible.
Thank you for your useful suggestion ... (in reality i used a more complex exception classification criteria based on different sublevels either for bad results and good results ) Now i will use only the bad 9 level for the third class
Is this valid also for the others colors ?
Add comment