Skip to Content
avatar image
Former Member

SAP IBP: EPM Conditional Formatting based on value in other KF

Dear SAP,

We have a request from the user for the formatting of the Planning View through the EPM. And we cannot find a solution through EPM, so I would like your help on this topic.

We have a KF (called KF "A") that calculate the percentage (normally 100%) but we want highligh that cell in different colours based in another KF (called KF "B"). If this KF "B" has a negative value, the value in the KF "A" should be filled in red colour, but if this KF "B" has a possitive value, the value in the KF "A" should be filled in green colour.

It is possible do this with the EPM?

I saw that we can apply the conditional formatting, but this is based on a value, or a range, but not based on the value of another KF in the same month.

Could you help us?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 17, 2017 at 03:53 PM

    "I saw that we can apply the conditional formatting, but this is based on a value, or a range, but not based on the value of another KF in the same month."

    Yes, conditional formatting is a correct approach for this requirement. What's the issue???

    Show the report and formatting sheet screenshots!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2017 at 11:27 AM

    Thanks Vadim for your awer, my question is how I can put conditional formatting for one KF but based on the value on other KF.

    In the EPM I can add one KF, and I can put condicional formation for this KF, for example it this KF has a value less tan 0, one color, and another color if the value is more tan 0.

    But I want that this KF has one or another color if the value in a different KF has one or othe value. Is it posible add two KF in the EPM and apply a condifional formatin to allow this behaviour?

    I attach one screen of the existing EPM format, but I cannot add what I want.

    epm-format.png

    Add comment
    10|10000 characters needed characters exceeded