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.