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

[Former Member]

Hi,

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

case:

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,

Hassan

[former_member186338 · Accepted solution]

First of all it's better to use script logic in default.lgf to perform saving to different AUDIT ID.

For report you can use EPMCopyRange to put the formula in the data cells of the dynamic report.

[former_member186338 · Accepted solution]

P.S. EPMAxisOverride is not related to the subject...