sqrt

Description

Returns the square root of a number.

note

This is the inverse of power(number, 2).

Syntax

Like many functions in DataPrime, sqrt supports two notations, function and method. These interchangeable forms allow flexibility in how you structure expressions.

Function notation

sqrt(number: number): number

Method notation

(number: number).sqrt(): number

Arguments

Name	Type	Required	Description
number	number	true	The value to compute the square root of

Example

Use case: Compute rate of return over 2 years

Calculate the rate of return for an asset purchase and sale by taking the square root of the price ratio and subtracting 1.

Example data

{
    "buyer": "Chris",
    "asset": "DataDog",
    "bought_at_price": 100,
    "sold_at_price": 10
}

Example query

Function notation

create ror from (sqrt(sold_at_price / bought_at_price) - 1)

Method notation

create ror from ((sold_at_price / bought_at_price).sqrt() - 1)

Example output

{
    "buyer": "Chris",
    "asset": "DataDog",
    "bought_at_price": 100,
    "sold_at_price": 10,
    "ror": -0.683772233983162
}