Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Local member in EPM report to calc % of total

Hi,

I need to create a report that looks like this.

The percentage must be calculated as the account per row divided by the total shown in the row at the bottom.

I tried to create the local member with excel cell references (i.e. B4/B11) but that breaks when I expand one of the accounts shown, i.e. the B11 reference stays and so the calculation uses the wrong account.

I then had a look on the EPM Add-in Academy and found a video showing a solution that uses an EPMRetrieveData function in the local member. I replicated that in my environment (BPC 10.1 NW, EPM Add-in SP 20 .NET4) and all I get is an error message saying the function cannot be used. I tried this in my original report and then also tried to replicate the report from the video 1:1 and got the same error in both cases.

Would anyone have a solution for this report?

Thanks,

Arnold

Tags:
Former Member
replied

Never use ";" in local member formula - use US standard - ","

Vadim

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question