TM1 Forum

Posted: **Tue Sep 29, 2015 11:25 am**

Hi guys,

Has anyone dealt with this kind of requirement in which there's a formula raising a negative number to a fractional power?
Excel and TM1Web give different results for different samples. What we're trying to make a work-around for is when TM1Web gives #NUM result, when Excel gives a valid result (although this is debatable whichever is correct).

Sample:
((-0.50801678102775)^(1/5))-1

Excel gives -1.8733 while TM1Web gives #NUM error.

Thanks in advance for your feedback.

Posted: **Tue Sep 29, 2015 12:03 pm**

Actually, TM1Web doesn't give anything, it's what the TM1 engine returns. You can't use a fractional power in TM1 (in your case the 1/5) so the result is an error in TM1.

Posted: **Wed Sep 30, 2015 12:29 am**

Hi,
You could use this kind of formula in TI to pre-calculate the results if practical.

Code: Select all

nMthlyRate = ((1+ nAnnualRate  )^( 1/12 ))-1;

I have been using it for rates conversion for example.

TM1 Forum

Raising negative number with fractional powers

Raising negative number with fractional powers

Re: Raising negative number with fractional powers

Re: Raising negative number with fractional powers