TM1 Forum

Hi all,

Please could you help with a (hopefully straightforward) question ?

I am building an allocation model where I want to spread overhead costs over a given basis (eg GWP), and I have built a TI process for this.

This works fine. There are some lines with zero GWP and it deals with these OK, but there are also some instances where the imported value I wish to divide by is not quite zero - eg "0.000004". This calculates through and gives me a massive allocation figure (eg £200 / .0000004 * 3 = £15m, whereas it should be zero).

Is there a simple function in TI that can round the selected input figure before doing the calculation? I don't want to round the output figure but would like to only accept an input (division) figure if it is 1 or more.


Thanks
Steve

conflax wrote: Is there a simple function in TI that can round the selected input figure before doing the calculation? I don't want to round the output figure but would like to only accept an input (division) figure if it is 1 or more.

You mean like ROUND or ROUNDP? Did you check the documentation? (Given that the "mathematical functions" only appear in the Rules guide and not in the TurboIntegrator guide so it might be possible for a 1st timer to miss but all the same it is (or should be) common knowledge that (almost without exception) rules functions can be used in TI processes, after all "This is a TM1® rules function, valid in both TM1 rules and TurboIntegrator processes" does appear at the top of every function description in the rules guide.)

Um... I thnk the word "D'oh" applies here. I also note this was posted in the wrong place too.

In my defence, it was early on a rough Monday morning...

Thanks very much.

Moved in to the right place.