RANDOM() Function

Excel Having two functions

  1. RAND
  2. 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.

5
5 votes

New · Last Updated

Comments

  • Atly1970
    edited February 13

    @ 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).

Get Started with Idea Exchange


See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!