Skip to Content
0

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

Oct 17, 2017 at 03:22 PM

79

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded

P.S. What do you mean by user tag "abap" for this question???? To be removed!

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Oct 17, 2017 at 03:53 PM
0

"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!

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 20, 2017 at 11:27 AM
0

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


epm-format.png (30.4 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Have to repeat: "show report screenshot"

0