Skip to Content
author's profile photo
Former Member

Exceptions wrong colors

Hi

did you ever notice errors in BEX expcetions?

In particular results wrong colors ... (pink on the results in spite of red and green )

How can i solve this "bug"

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    author's profile photo
    Former Member
    Sep 28, 2005 at 03:34 PM

    Go to the cell with the 'wrong' color.

    Choose format style from the menu, and change it like you want.

    If you want this to be the final state you will have to change the workbook template.

    kr,

    Tom

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 28, 2005 at 06:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 29, 2005 at 10:27 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 29, 2005 at 01:55 PM

    Hi

    I have a ABC Analysis query with tree levels on totals

    0-30 Red

    30-60 Yellow

    60-100 green

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Andrea,

      My reason for asking was just to confirm whether you have the Bad 9 level assigned, as this is the only one that will give you the Red color...other Bad levels deliver you shades of pink.

  • author's profile photo
    Former Member
    Sep 30, 2005 at 10:34 AM

    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
    10|10000 characters needed characters exceeded