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.

6
6 votes

New ยท Last Updated

Comments

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

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In