Raising negative number with fractional powers

[bunchukokoy]

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.

[tomok]

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.

[Olivier]

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.