Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

Random Function

There is an issue when trying to use any of the random functions that excel provides. 
Please review the long debug trip I went on just recently and posted to the community forums.
https://support.jetglobal.com/hc/en-us/community/posts/360027747193-Unpredictable-behavior-with-rand-function

My suggestion is for a type of random function to be built that will accept query criteria, and then randomly select "x" number of records to be displayed.  This could be a separate function like 
=NL("Random=NumberOfRandoms",other,filter,criteria)
but I actually think it works better as the extra command filter operator similar to "Limit".
=NL("rows","item","no.","random","10")

This can be used for acid testing from an accounting perspective, or for spot checking/cycle counting from an inventory perspective.  

  • Guest
  • Feb 22 2019
  • Under Consideration
  • Attach files
  • Peter Paterson commented
    20 Mar 19:01

    Fantastic idea!