Datameer Product Documentation
Spaces
Apps
Templates
Create
Datameer X v10
All content
Space settings
Content
Results will update as you type.
New and Noteworthy
•
General Information
Product Description
Setup and Installation
Administration Guide
Importing and Accessing Data
Working with Workbooks
Workbook General Information
•
Workbook Sheet Types
Datameer Functions
•
Alphabetical List of Supported Datameer Functions
•
Using the Formula Builder
•
Using Operators
•
Using Regular Expressions
•
Convert Data Field Types with Functions
Comparison Functions
Date and Time Functions
Encoding Functions
File Functions
General Functions
Grouping Functions
HTML Functions
List Functions
Logical Functions
Math Functions
•
ABS
•
BITAND
•
BITOR
•
CEILING
•
COMBIN
•
COMBIND
•
CONVERT
•
DIFF
•
DIV
•
E
•
EVEN
•
EXP
•
EXPLODE_RANGE
•
FACT
•
FACTD
•
FLOOR
•
GCD
•
GEOHASH_DEC_LAT
•
GEOHASH_DEC_LONG
•
GEOHASH_ENC
•
INT
•
LCM
•
LN
•
LOG
•
LOG10
•
LSHIFT
•
MOD
•
MROUND
•
ODD
•
PI
•
PLUS
•
POWER
•
PRODUCT
•
QUOTIENT
•
RAND
•
RANDBETWEEN
•
RANDGAUSSIAN
•
ROUND
•
ROUNDDOWN
•
ROUNDUP
•
RSHIFT
•
SIGN
•
SQRT
•
SQRTPI
•
SUBTRACT
•
SUM
•
TRUNC
•
URSHIFT
•
BIGDECIMAL
•
BIGINTEGER
Statistical Functions
Text Functions
Text Mining Functions
Trigonometry Functions
URL Functions
XML Functions
Smart Analytics
•
Smart Sampling
•
Workbook Inspector
•
Workbook Settings
•
Workbook Sharing Permissions and Security Settings
•
Workbook Details
•
Workbook Tips and Tricks
•
Creating a Workbook
•
Storing a Workbook
•
Viewing a Workbook
Working with Sheets, Columns and Cells
•
Adding Additional Data Soucres
•
Exchanging Data Sources
•
Using Variables Within Workbooks
•
Sorting Data
•
Filtering Data
Joining Data
•
Unioning Data
•
Pivoting Data
•
Deduplicating Data
•
Using Formulas
Working With Date and Time Information
Using SQL Sheets
•
Flipping a Sheet
•
Using Smart Analytics
•
Using the Visual Explorer
•
Reverting Actions
•
Launching Production Mode
•
Synchronizing Workbooks
•
Optimizing a Workbook
•
Completing Workbook Level Tasks
Exporting Data
Smart Execution
Guide for Developers
Visualizing Data
•
Glossary
Contact & Help
Blogs
Datameer X v10
/
/
Math Functions
/
RANDBETWEEN
Summarize
RANDBETWEEN
Juliane Wetzel
Owned by
Juliane Wetzel
Feb 07, 2020
Loading data...
Syntax
RANDBETWEEN(<
number
>;<
number
>)
Description
Returns a random number between the numbers that you specify.
Examples
Column1
Column2
RANDBETWEEN() returns
4
5
4.7091995504673365
5.5
6
5.52674167149901
5.5
-6
-1.1110290234600715
{"serverDuration": 14, "requestCorrelationId": "dbd6d3a54e20478d826ae5d7cadf2c44"}