Skip to Content
Former Member
Sep 20, 2016 at 11:21 AM

How to use 'keep formula on data' option for dynamic report



I'm struggling with the formula 'keep formula on data' option in my report.


In my default report 000, i have a dimension company code, and country, Time and AUDIT (input).

In my second report 001 (same sheet), i have the same report setting (sharing the rows), but only with a different Audit ID (Adj).

The report 001 should save the result from 000 but multiplying it with -1 ( *-1) on company, country, Time and AUDIT ID (ADJ).

The EPMAxisoverride formula didn't work and the 'formula on data cell' is not saved (option checked in the report editor).

Any suggestion/idea? please let me know.

Best Regards,