Skip to Content
author's profile photo Former Member
0
Former Member

Exceptions wrong colors

Posted on Sep 28, 2005 at 03:24 PM 28 Views

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

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Tom Francis
    Tom Francis
    Posted on Sep 28, 2005 at 03:34 PM
    1

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

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

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

  • author's profile photo Andrea Previati
    Andrea Previati
    Posted on Sep 29, 2005 at 10:27 AM
    0

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

  • author's profile photo Andrea Previati
    Andrea Previati
    Posted on Sep 29, 2005 at 01:55 PM
    0

    Hi

    I have a ABC Analysis query with tree levels on totals

    0-30 Red

    30-60 Yellow

    60-100 green

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Andrea Previati
    Andrea Previati
    Posted on Sep 30, 2005 at 10:34 AM
    0

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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.