Skip to Content
0
Former Member
Mar 12, 2009 at 02:05 PM

EVDRE Input Schedule - shifting of cells/formulas

16 Views

Hi everybody,

I am using BPC version 5.1. I do have a problem with an EVDRE Input Schedule. It is a single EVDRE report which is nested with a product and an account dimension.

Underneath the Data Input Range, I have written additional information and included a button with the send function. If I change the selected product members through another button which is above the input range and expand the report, the additional information and the button always move one row up when expanding.

Has anybody experienced a similar problem or has a solution for the problem? I am happy to provide additional information.

On top of that problem I do have cell reference sin formulas that also change when expanding. I e.g. have a EVPROP formula that shifts the row in the reference one row up each time I expand. The formula is on the left side of the input range next to the row IDs. I don't know why, but this problem doesn't occur on all input schedules.

Does anybody have a clue how to solve the issue?

Thank you very much in advance!

Christopher