RANDOM() Function

Excel Having two functions

RAND
RANDBETWEEN

both function generates random numbers, it will be very useful for model builders and end users to use same function in anaplan.

please suggest can we get same function in anaplan.

Comments

Atly1970

@ Block Blast, You can create a pseudo-random number by leveraging MOD() and CUMULATE() on some existing number series.
Example: MOD(CUMULATE(1, 1, 1), 100) (adjust to get different ranges).

Quick Links

New ideas

Allow non-WSAs to view source module name in UX.
When a user clicks the ellipsis in a grid card they should be able to see the name of the source module. This empowers end users with the ability to connect to the source data they see in the UX to the module in the backend. It also enables end users to pull the data into Google Sheets or Excel.
A function that identifies all saved views which filters are broken
I would like the function to identify all saved views which filters are broken(error).
Add feature to “Use Account Style Drilling” in AnaplanXL Grids
This feature to display children above the parent when drilling in is available in AnaplanXL freeform but not grids. This would be a useful feature in Grids as well. As a user, I would expect to have same/similar functionality between Grids and Freeform.