Skip to Content

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

Question on local member formula

Hi experts,

I have a simple EPM report which shows accounts in rows and datasources and entities in columns. I have selected one datasource and several entities. The datasource is a fixed selected member, the entities are select as all base level elements of a node which have a specific property value.

I now need a total column in my report. When I let EPM do it I get a formula like:

=SUM(EPMPOSITION(1), EPMPOSITION(2),...)

Such a formula is not dynamic which means I need to update the local member every time I add a new entity.

I tried this:

=SUM(EPMSELECTEDMEMBERS(ENTITY))

But that only summed the final column, not all of them.

Can anyone help me on making this formula fully dynamic?

Thanks,

Arnold

Tags:
Former Member
replied

Still looks like that in all reports you have some fixed member in column axis and another is a list of members...

Anyway, magic formula for local member to sum from the first report column to the last report column:

=SUM(EPMPOSITION(1):INDIRECT(ADDRESS(ROW(),COLUMN()-1)))

Vadim

P.S. Assuming that local member is in the next column after the last data column: "COLUMN()-1"!

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question