Skip to Content

Hi all,

 

I would like to share with you some knowledge on how to format specific time buckets.

  1. <relative> property of the time bucket
  • Select required KF & Add to Multiple Selection

1.JPG

  • Go to Property Selection, make your selection and add it to Multiple Selection as well.

Below selection will return the combination between KF and Current Time Bucket + 2 (you can check your selection in Multiple Selection Overview tab)

2.JPG

  • Result:

4.JPG

As current month is July the format is applied to September (July  + 2).

3.JPG

I have tried with other operators (different than ‘=’) but, unfortunately, it didn`t work as expected. To have time range dependent format please check below workaround:

 

2.  Excel workaround

 

I started from the requirement of having a yellow fill for Sales Fcst Price in [Current Month, Current Month + 3] time range

  • I added some dummy entries for Current Date+3  and another row to return the Time Bucket Header date in the same format.

H15 points to Current Date + 3  using the following formula =DATE(YEAR(TODAY()), MONTH(TODAY())+3, 1)

5.JPG

  • Then I inserted a Local EPM member DATE with the following calculation: =IF($H$15>H16,1,0)
  • I added Conditional Formatting to Sales Fcst Price so that format to be applied when DATE equals 1

7.JPG

It works also w/o creating local member as below and point the conditional formatting to H18.

8.JPG

This trick could be applied also for locking cells in a specific time horizon.

If you know any other workaround please share!

 

Regards,

Alecsandra

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply