TM1 Forum

Hi everyone,

I have an active form and I bring the number on another excel cells, as the image "ActiveForm1". Until here it is ok. I bring the number 900 and 800.

But after I use "recalculate" I got "#REF" (image "ActiveForm2") on the cell that brings the number 800 of active form. Only the first row of the cube it is working.

Does anyone have any idea of what is happening?

Thanks in advance.

JR

Please post the formulas for Test1 and Test2.
Do they reference the cube or the TM1RptView cell?

Hi, find attached the images.

The cell refer to the active form, where is the DBRW rule.

Thanks.

You can't directly reference a cell that is part of the active form because the active form rows are deleted and rebuilt each time you rebuild. This will kill any formula that directly references any part of the active form. Look into the OFFSET and/or INDIRECT formulas in Excel. This should solve your problem.

Hi, the function offset solved the problem.

Thanks a lot for helping me.

Regards,

JR