on 06-17-2016 7:02 AM
Hello Experts , I have a requirement to make color coding for the cells for only the frozen horizon eg: first 9 weeks of horizon for specific key figures like Production receipts , adjusted project receipts . I tried the EPMformattingsheet functionality but not able to arrive at this.
Your help on this would be highly appreciated.
Cheers,
Ganesh
Hello Team - Your help on this would be highly appreciated , pls let me know your thoughts.
Cheers,
Ganesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ganesh,
This requirement is not very straight forward. However i might think of a solution.
e.g: having an extra row on top of your time axis and a formula to return 1 or 0 if the week is in the 9-week horizon or not. Then you could apply conditional formatting from EPM based on the values of 1 or 0.
Regards
Alecsandra
Alecsandra & Others - Per your suggestion i have added keyfigure to return the value 1 or 0 and with condition formatting it works . However users may not wish to see those additional keyfigures which populated for each material location combinations . In this case im trying to hide the newly added keyfigure (which returns value 1 or 0) as below attached screen shots however this is not working i.e the keyfigure is not getting hidden .Pls refer the below screen shots and let me know your thoughts
Hi Ganesh,
Rather have the calculation based only in excel which can be hidden to the user within your planning view. You can have a formula that extracts the date from the time axis and compares with sysdate / current date + time buckets that are part of your frozen horizon. Then use these calculations as input to your conditional formatting.
Regards
Alecsandra
HI Ganesh,
You can shift those calculations at the very right end of your planning view and hide (if still needed) with excel standard functionality. Or you can try having them on a separate worksheet which is hidden to the user.
I can share with you an example, just drop me an email a.ghita@sap.com
kr,
Alecsandra
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.