Skip to Content

BPC Conditional formatting - Local member

Hi, We are using BPC conditional formatting on a LOCAL MEMBER showing variance between Actual & Budget - In the conditional formatting manage rules for local member we have show as

Red - if less than 0

Green - if greater than 0

sign.jpg

However, due to the natural signage of BPC which is show INC as - even though it is Net profit which BPC is showing as -, the color is coming up as red. How to overcome this.

we need to see profit as positive/green and expense if less than budget as positve..

sign.jpg (28.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 29, 2017 at 09:05 AM

    Sorry, but what is the issue?

    On the screenshot I see comparison between actual and budget. For revenue the result is negative - looks correct!

    P.S. Please do not attach pictures with "Insert File", use "Insert Image" instead: https://answers.sap.com/articles/351263/hate-list.html

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 30, 2017 at 08:27 AM

    Sorry, but I unable to understand your issue. In my test:

    You can clearly see that EPMComparison will provide correct negative result if ACT < BUD

    Same correct result if Net income ACT is negative and BUD - positive:

    etc.

    Add comment
    10|10000 characters needed characters exceeded

    • "If Net income for ACTUAL is higher than BUDGET then also it gives negative result as BPC shows - sign for all INC accounts." Sorry but in correct report with correct setup the result will be POSITIVE (look on my screenshot)!

      And conditional formatting has no relation to the question!

      Test without any formatting and you will see correct results.

  • Nov 30, 2017 at 04:28 AM

    Please refer to below screenshot. The issue is since Actual profit is higher than budget it should not show as red, and since FX P/L is higher in Actual it should not show as green. How to achieve this.

    We want net profit to show as green, and unrealised gain/loss as red.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded