spread via excel
Posted: Wed Oct 13, 2010 10:26 am
Hi,
I have another issue.
I want to put a spread function in an excel worksheet. I cannot use the the spread menu of the TM1 form because the dimensions on which I want to spread are in point of view and not only in row or column.
I found that there is a TI function called CELLPUTPROPORTIONALSPREAD that can do what I need, the only problem is that,
If I put a value in a consolidate cell, obviously, the TM1 gives me an error and doesn't save the new value, so I have not a base on which to start the TI spread process.
Have you ever met an issue like this? how can I workaround this?
thanks in advance.
Stefano
I have another issue.
I want to put a spread function in an excel worksheet. I cannot use the the spread menu of the TM1 form because the dimensions on which I want to spread are in point of view and not only in row or column.
I found that there is a TI function called CELLPUTPROPORTIONALSPREAD that can do what I need, the only problem is that,
If I put a value in a consolidate cell, obviously, the TM1 gives me an error and doesn't save the new value, so I have not a base on which to start the TI spread process.
Have you ever met an issue like this? how can I workaround this?
thanks in advance.
Stefano