Skip to Content
Oct 20, 2016 at 09:14 AM

EPM Reporting 10.1(Classic): Keep Formula Functionality not working!


Hi Experts,


My requirement is to create multiple input templates where in one of the templates, values are coming from another input template (sheet) of the same file through simple excel cell references formulas.

For the same I have used "Keep formula on Data" functionality on target so that whenever data changes in source sheet it updates data in target sheet even after refreshing the parameter.

But the same is not working as whenever I changes parameters in source sheet, it is giving error in target sheet and it seems that cell reference formula is not able to survive.

Please guide.!!

Also suggest other ways to fulfill my requirement in EPM, if any.