Hi,
I noticed that active forms which have 3 column like Program, P&L Cat and Exp type- have the issue when you insert a new column between Program, and P&L Cat column and re-run or re-build the sheet the report - data in this report diappear.
When checked with other active form report where where we have 1 column - i am seeing data after re-calculate.
Please advise
Ravi
Active form Insert column issue
-
vinnusea
- Posts: 116
- Joined: Thu Sep 23, 2010 6:12 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
- Location: San Diego ,CA
Re: Active form Insert column issue
Hi,
What i suggest you is before you insert a column please check for manually written formulas having any obsolete values .If cells are difined as absolute then when u insert a column the formula still looks for the old cell value.
Ex: there is a calculation like IF($G$5 = "ABCD",$G$8&$G$9, "") and when you insert a column in between C&D then your formula must shift to IF($H$5 = "ABCD",$H$8&$H$9, "") but it will not as they are absolute values. They should be like IF(G$5 = "ABCD",G$8&G$9, "") which sticks to row reference and column reference may change on new columns.
Thanks
What i suggest you is before you insert a column please check for manually written formulas having any obsolete values .If cells are difined as absolute then when u insert a column the formula still looks for the old cell value.
Ex: there is a calculation like IF($G$5 = "ABCD",$G$8&$G$9, "") and when you insert a column in between C&D then your formula must shift to IF($H$5 = "ABCD",$H$8&$H$9, "") but it will not as they are absolute values. They should be like IF(G$5 = "ABCD",G$8&G$9, "") which sticks to row reference and column reference may change on new columns.
Thanks
Thanks
Vinnusea
Vinnusea