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
Help on Active Form
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Help on Active Form
- Attachments
-
- ActiveForm1.jpg (143.27 KiB) Viewed 3041 times
-
- ActiveForm2.jpg (131.62 KiB) Viewed 3041 times
- gtonkin
- MVP
- Posts: 1201
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Help on Active Form
Please post the formulas for Test1 and Test2.
Do they reference the cube or the TM1RptView cell?
Do they reference the cube or the TM1RptView cell?
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Help on Active Form
Hi, find attached the images.
The cell refer to the active form, where is the DBRW rule.
Thanks.
The cell refer to the active form, where is the DBRW rule.
Thanks.
- Attachments
-
- Img1.jpg (124.79 KiB) Viewed 3032 times
-
- Img2.jpg (131.56 KiB) Viewed 3032 times
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Help on Active Form
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.
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Help on Active Form
Hi, the function offset solved the problem.
Thanks a lot for helping me.
Regards,
JR
Thanks a lot for helping me.
Regards,
JR