2.0.9.16 and ROUNDP broken by fix

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

2.0.9.16 and ROUNDP broken by fix

Post by JohnO »

FYI to anyone moving to 2.0.9.16 and using ROUNDDP with negative parameters.

We have just upgraded to 2.0.9.16 (Only to address vulnerability: https://www.ibm.com/support/pages/node/6856457) a few days ago and have found that our use of ROUNDP is no longer working. We are passing -2 and in cases where we have something like .0000024 as the number to be rounded we are getting crazy numbers 1,000,000 and similar . -1 is giving the same result.

In the fix notes: https://www.ibm.com/support/pages/syste ... 0916-1.pdf

I see this: "The ROUNDP function rounds 0 and null values to "10000000000000000" when the decimal precision parameter is "-2"or any lower value" with the detail in the following

https://www.ibm.com/support/pages/apar/PH52125

But it seems that their fix has broken the function.


UPDATE: IBM RESPONSE IS THAT THIS WILL BE FIXED IN 2.0.9.17
Post Reply