Anyone Know About TM1 Function RoundP

Post Reply
Niko
Posts: 50
Joined: Tue Feb 15, 2022 6:43 am
OLAP Product: IBM Cognos TM1
Version: PA 2.09 / TM1 11.7.00000.42
Excel Version: EXCEL 2019
Location: Asia

Anyone Know About TM1 Function RoundP

Post by Niko »

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
User avatar
qml
MVP
Posts: 1094
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

Post by qml »

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
JohnO
Posts: 92
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

Post by JohnO »

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)
Post Reply