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. :)
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context andβ¦
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-yearβ¦
