Skip to Content
0

Excel formula in EPM report

Apr 17, 2017 at 06:46 PM

42

avatar image


I have a dynamic report consisted of 100 lines which specifically selected in report. Now I need insert a line in between 50 lines for totalling. EPM local member formula works fine. But customer wants to know why can't we use excel formula than local member.What are the benefit of using local member formula in such case.

Appreciate inputs.
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Apr 17, 2017 at 07:12 PM
0

You can insert Excel formulas directly in the cells only for static report - read: https://blogs.sap.com/2013/03/01/static-report-in-bpc-nw-10/

If you change members in row or column axis then Excel formulas will be removed. The line with the local member will be present if it's positioned to some existing report member.

Just try yourself!

Share
10 |10000 characters needed characters left characters exceeded