TM1 Forum

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

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