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

Need different colours for Profit and Loss

Hi Experts,

I have Profile and Loss report which is having Profit and Loss as per my requirment i need to give two different colours for profit and loss

As per my knowldge we can give different colours based on less than, greater than, equal etc... but i need for all values either it may be nagative or possitive vales. how can i do this?

Thanks - Venkat

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Aug 31, 2013 at 04:15 AM

    Have you tried with "Exceptions" in BEx Query?

    Otherwise you have to format your workbook in BEx Analyzer. There will be format option in the top context menu.

    Follow this : http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c047853e-15bf-2d10-808a-b81acc227a83?overridelayout=true

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 31, 2013 at 04:19 AM

    Hi Siva,

    I think thru bex you can't get what you need. you may try on BO tools if you have.

    other wise get out result into excel do it as manually.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 02, 2013 at 09:15 AM

    Hi Venkat,

    As per your comments you want to differentiate profit and loss in different colors.

    How you identify the profit and Loss ? I mean on what logic you will identify Profit and Loss values?

    Thanks

    Aakash

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      If you have separate KF for profit and loss i,e 2 different columns for Profit and Loss.

      As per understanding you want to differentiate both columns with i,e profit and loss with different colors right?

      If this is your requirement then follow Suman's reply.

  • author's profile photo Former Member
    Former Member
    Posted on Sep 02, 2013 at 11:49 AM

    Hi Venkat,

    As it depends on keyfigure values. You can do if by defining exception on those keyfigures.

    For profit keyfigure, find a least value that will never come in that keyfigure. Then give exception as greater than. Suppose you can keep a value 1 and exception greater than as good1.

    This way you can also choose between/not between operator. For example, if your profit keyfigure has both positive and negative values. You can select good1 for not between 1 and -1.

    Likewise, Choose the color band for loss by appropriately selecting the value so that all the values that comes in the loss keyfigure covers.

    Regards,

    Mohammed.

    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.