cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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



Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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

Answers (0)