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.
Raising negative number with fractional powers
-
- Regular Participant
- Posts: 197
- Joined: Thu Dec 03, 2009 8:47 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2.x
- Excel Version: 2010
- Location: Singapore
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Raising negative number with fractional powers
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
- Community Contributor
- Posts: 159
- Joined: Thu Jun 26, 2008 5:46 am
- OLAP Product: TM1
- Version: Tm1 10.2.2fp4 -> 2.09
- Excel Version: Excel 2013 - 2019
- Location: Sydney
Re: Raising negative number with fractional powers
Hi,
You could use this kind of formula in TI to pre-calculate the results if practical.
I have been using it for rates conversion for example.
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;
HTH
Olivier
Olivier