Need different colours for Profit and Loss

[former_member215567]

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

[Former Member]

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.

[Former Member]

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

[former_member215567]

Hi Aaksah,

We have two different 2 key figures for profit and loss

Thanks - Siva

[former_member182470]

have you missed my reply? I asked you previously also. You never bothered to reply. What is the point in replying to you?

[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.

[RamanKorrapati]

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

[former_member215567]

Hi Ramanhaneyulu, thanks for your sugession,

But we are not using BO tools

Thanks - Siva

[former_member182470]

You missed my reply?

[former_member182470]

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-b81acc227...