TM1 Forum

Hi,

i searched the forum and I saw that there is already a topic about it, but it is not exactly the same situation.

The fact is that spreading a value on a member that is a parent and it was 0 previously issue this error.
Apparently it is because there is no mix under the parent to spread a value proportionally.

The fact is if I want to put a value of 100 in a cell 0 I get the error and the process blocks.

Now I'm asking. is there a way to workaround this? I mean ideally the thing to do is:

if the value <> 0 then cellputproportionalspread else "execute an equal spread".

any Idea in how to solve this?

stingo wrote:if the value <> 0 then cellputproportionalspread else "execute an equal spread".

Why not just do as you've suggested? If the value is <> 0 then use the cellputproportionalspread, if not, your else conditon would include the steps to put an equal value in each child. Query for the number of children of the parent, divide the amount by that, then have looping code to cycle through the children and put that calculated value in them. Good luck.

tomok wrote:

stingo wrote:if the value <> 0 then cellputproportionalspread else "execute an equal spread".

Why not just do as you've suggested? If the value is <> 0 then use the cellputproportionalspread, if not, your else conditon would include the steps to put an equal value in each child. Query for the number of children of the parent, divide the amount by that, then have looping code to cycle through the children and put that calculated value in them. Good luck.

hi,

yep, in the end I've implemented manually the condition.