TM1 Forum

Hi all, thank you for your comments and heading me into the right direction. Finally, I came up with this: SKIPCHECK; ['Total Year Input'] = N: STET; []=N:IF(ELISCOMP('DIM_TIME',!DIM_TIME, 'Total') = 1 & ['Total Year Input'] <> 0,(['Total Year Input']\12),Continue); ['TVC in %']= ['Total Variabl...

Hi Tomok, thanks for your reply. My time dimension has these values: Total Year Input (n-element)/Total (C:element)/Apr (n-element)....../Mar (n-element)/Prev FY FC/ LTM Actuals I wanted to achieve that the value of the Total Year Input will be distributed to the months. But for some reason , It wor...

Hello Lotsaram,

It worked.
Thanks a lot.
The code is not the best one, but could be improved.
Code is attached.

Hi Lotsaram,

thanks for your reply. I will test this.

Regards,
Erik

Hello all, I am just in the process of migrating 7.3 Cognos Planning apps to TM1. But now I am experiencing issues with the copy/paste from Excel in TM1 Contributor. My finance users want to copy data from Excel and paste it into TM1 cube view. There are users that copy the data for the next 12 mont...