Skip to Content

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

Hi Experts,

Requirements:

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.

Thanks,

Karan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 20, 2016 at 09:42 AM

    Use both options:

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2016 at 09:49 AM

    Thanks a lot Vadim..!!

    It works!!

    Regards,

    Karan

    Add comment
    10|10000 characters needed characters exceeded