Dear Anaplan Community,
I need help to round numbers up to the nearest number ending in 5 or 0
2233 — to 2235
2888 - to 2890
Any intakes?
Hi @CCOLMANT,
One way you could do this would be to divide whatever number you're referring to by 5, round the result to the nearest number, then multiply by 5. Effectively: ROUND(Value/5,0) * 5
Consider using the Anaplan function MROUND, you may find more info in Anapedia
The function is similar to Excel's, except with an added flexibility to add a rounding direction too
@derektslim Good point! I actually discovered that formula soon after responding to the original post. :)
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
