Rounding function showing inconsistent results

We are getting some inconsistent results with round function in Anaplan which is causing bit of an issue at a client's end . I have seen few posts relating to round function so may be a know bug . Just trying my luck if anyone has been able to solve this .

Below is an eg.

Please note how rounding formula behaves differently for Input 1 (rounds up) and Input 2(rounds Down)

Here is the blueprint

All line items are formatted as follows

thumbnail_image001_52960.png

Accepted answers

stephen.brook

Hi - we're sorry you experienced issues with ROUND. In this weekend's maintenance window, we've added a new ROUND mode that addresses the issue you've observed. Here's your example using the new EXACT mode for ROUND:

You can find more detail on the change here: https://community.anaplan.com/t5/Releases/What-s-new-November-23-2019/ba-p/54370

And we've updated Anapedia to reflect the change, and added some further examples: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ROUND.html

Thanks, Stephen

All comments

Misbah

@karank

What is the expected outcome in the output line item? For example Input 1 is 31.49500 - how do you want to see these numbers in the output line item - 31.495 or 31.5 or any other specific way

Thanks,

Misbah

karank_*4578

@Misbah I just what it to be consistent so either both 31.49 or 31.50. Reason i say this is because we have tried few things like replacing 100 with 10 in rounding formula but it works for some scenarios and breaks for others . Unable to get a consistent result with rounding function

Misbah

@karank

Can you try this and see if this helps

Remove Round Function from the formula and - and keep your decimal places in the output line item to 2 or 3 whatever your requirement is

For example in my case I have kept the setting as as 4 Minimum significant digits & 2 Decimal places. I am getting the desired result because Anaplan automatically rounds it if you keep lesser decimal places than the input line item.

See Screenshots in attachments

Thanks,

Misbah

Capture_1_52981.JPG

Capture_2_52981.JPG

karank_*4578

@Misbah This approach works for display only . However when you extract data it extracts all digits in csv.

vsbwofficial

Maybe it's because of formating it's not showing desired results

nathan_rudman

Hi,

Round is known to have an issue as found in this topic. Your is different but might be related to the underlying engine as well.

I tried to reproduce it as well but I couldn't. My module rightly display 32.49000

Have you raised this case to support ? It would be interesting for us to be able copy copy this model to be analyzed.

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/ROUND-Function-Not-Always-Rounding/m-p/7290#M333

karank_*4578

@nathan_rudman

yes i have now . Support has acknowledged this as a bug .

stephen.brook

You can find more detail on the change here: https://community.anaplan.com/t5/Releases/What-s-new-November-23-2019/ba-p/54370

And we've updated Anapedia to reflect the change, and added some further examples: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ROUND.html

Thanks, Stephen

karank_*4578

@stephen.brook Exact solved this issue

Thanks

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…