Function that will generate random numbers, between specified min & max values.
Excel has two functions to provide random numbers:
RAND() generates a decimal value between 0 and 1
RANDBETWEEN( x , y ) generates an integer >= x and <= y
It may be worth considering an extension to these functions such as:
RANDOM( x , y , z) where z dicatates the increment of allowable values between x and y
RANDOM() = 0.0001, ... 0.9999
RANDOM( 2 , 7 ) = 2, 3, 4, 5, 6, 7
RANDOM( 2 , 7 , 2 ) = 2, 4, 6
RANDOM( 2 , 7 , 0.5 ) = 2.0, 2.5, ... 6.5, 7
Status changed to: In Review0
So there is one main problem with a calculation function that produces different values every time that it is used. In order to calculate efficiently Anaplan will choose to re-calculate particular cells or not according to strategies that are not in control of the customer. This means that your values will change at times that you have no control over, including every time the model is loaded.
What would seem to make a lot more sense would be an action, where the admin would choose a data-entry line-item and when (and only when) the action is run it would fill the line-item with random numbers (according to other parameters entered when the action is created and edited).
What do people think? Would this serve the purpose as well as a function?0
Duncan, I think your proposed solution would fill the need exactly.
The reason I personally am looking for random number generation within Anaplan is for creating sample data and dashboards - I want to create a dashboard proof of concept that is not just boring flat lines, but not have to go and type different numbers for all the cells. A on request random data generation tool of some sort would be perfect. I would be in support of that feature request.0
For us also this new action "random" would fit our requirement, it would avoid us to have to interface a random list of numbers from an external tool each time we want to run a new calculation.0
I definitely concur with @duncan_pearson -- @NoahJ's use case is exactly my own.0
This would be highly beneficial in some cases. I see it has been added to back in July 2018, and now in "considered for future roadmap" state. Is there any update?0
@duncan_pearson how can be done technically ?0
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!