Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
470
Formula Builder Rand Function
posted

Can someone tell me what the Rand() function in the FormulaBuilder is meant to do? A user discovered that when he uses the function it inevitably brings down the application. It appears that it calculates a decimal between 0 and 1. I would think it would do this once per row. However, it calculates each row over and over constantly regenerating which takes up 50% of the cpu and eventually freezes up the app from accepting input.

The RandBetween appears to regenerate each row's value a few times before eventually staying static and not hosing the application.

Thanks in advance.