cancel
Showing results for 
Search instead for 
Did you mean: 

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

karan_kothari2
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Use both options:

Answers (1)

Answers (1)

karan_kothari2
Participant
0 Kudos

Thanks a lot Vadim..!!

It works!!

Regards,

Karan