Anyone Know how to use TM1 FUNCTION Roundp like excel round function, and is curious about different tm1 version will get different results:
Excel:
Round(0.615,2) =0.62
Round(0.625,2) =0.63
TM1 11.6
RoundP(0.615,2) =0.62
RoundP(0.625,2) =0.62
TM1 11.8
RoundP(0.615,2) =0.62
RoundP(0.625,2) =0.63
Anyone Know About TM1 Function RoundP
- qml
- MVP
- Posts: 1095
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Anyone Know About TM1 Function RoundP
Excel uses "round away from zero" tie breaking. TM1 is supposed to use the "round down" method for tie breaking and has used it for decades. So I would say the behaviour you reported for 11.6 is expected and the one for 11.8 is unexpected, but maybe they have changed it to align it with Excel. Documentation schmocumentation, amirite?
Kamil Arendt
-
- Posts: 115
- Joined: Mon Jul 29, 2019 5:02 am
- OLAP Product: Planning Analytics
- Version: 2.0.9.x
- Excel Version: Office 365 16
Re: Anyone Know About TM1 Function RoundP
Can you be more specific about which version you are working with. Did you see my post of the other day? They have made changes in the latest release PA 2.0.9.16 (I am using IBM's PA release numbering rather than TM1 Server numbering)