on 10-14-2014 3:57 PM
Hi,
I have a problem with a report. I want insert a Cell with TOTAL (SUM) but in a upper cell I have EPMCOPYRANGE
Ex:
I have first dynamic report, start in cell X10 and have 10 rows. In tje cell 11 active localmember with SUM(X10:X19). In a first moment it's ok but when end process show formula X9.
I don't know as solve it. I have proved with a blank member.
Thanks.
David.
Hi David
You can do the same by creating a new report below the dynamic default report as above.
In the report report, keep the context same as that default report for page axis & column axis.In case of rows, create a member "Total" and then create a epmcopy range for the new report with SUM() of default report.
Regards
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
=Sum(EPMALLMEMBERS)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
=EPMPOSITION(1)+EPMPOSITION(2)+EPMPOSITION(3)+EPMPOSITION(4)+EPMPOSITION(5)+EPMPOSITION(6)+EPMPOSITION(7)+EPMPOSITION(8)+EPMPOSITION(9)
or =SUM(EPMPOSITION(1):EPMPOSITION(9))
not sure I understand what you want to achieve
Hi David,
the formula of the EPMCOPYRANGE will indeed override any formula in the report below.
I suggest not to use the EPMCOPYRANGE, but to look at the formula in the cell X10 and insert it in the formatting sheet in the data cell with an apostrophe before and replacing any ";" by ",".
Insert it using a criteria that is true for the rows that it should be applied to e.g. row - dimension property calc = N. In this case your local member formula will keep any dynamic formula you insert.
kind regards,
Christophe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.