[{"id":"a20f26ac-cd31-4e4d-9454-1e035b0f1587","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"3604b8ce-1da0-413f-8274-7df0f7173573","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"7fce7040-1bb1-4a61-9fb7-2e19d569de50","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"0eb72dd3-8f8f-4039-93a8-500bbde2301e","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"ac046cee-82b9-4edf-a642-ae6d7cb21ebf","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"75b66fd4-b740-443d-bc6e-1782048b60a6","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"dde44832-bb5c-45f3-8ebf-3badbc613cd9","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"43de3664-261b-4cf9-9945-fb519251f4c7","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"2f064d57-b088-4bc5-a628-4e0d7e1a0c65","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"f290406b-ced1-4c52-abad-979160a79f6b","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"1864834b-08ce-43f1-891b-c3cca6e04e95","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"f96cfec1-420c-4ca7-ab0a-cab482731073","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"3f2ea860-c764-43d8-ae3f-6e3b0314ce67","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"81eb70e8-f770-4384-9167-bc7c755ad052","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"d0dff477-9f56-483a-a9fc-cab648905b41","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"793a62d7-460d-4699-9304-edb2941268ac","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"2d6ebfad-f7d1-4cc5-8ba1-fdace3472056","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"c8c7b5d5-f5bd-4b68-a12f-3aae9804a844","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"577a09da-dea1-42db-812f-4eeaa9274ece","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"8ddd80d5-886f-41b8-8e3f-f73aa8146c8d","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"e0909540-8bde-4587-bb4d-02445746db2a","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"464b8e03-462d-4aed-8818-05d32ec3bf00","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"f235557b-9781-471f-bf03-38bae6e3e953","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"fd5d021d-0210-4d74-ba42-1a39ef14a385","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"548568fe-dbd1-4da5-a489-d9b3edf75329","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"a0c823ed-e22b-493b-aded-4d201c0fa480","tags":[{"product":null,"links":null,"id":"fe610228-9cf6-417f-813a-dcbfd25406c3","name":"upd","color":"#7e678a","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"d19bc9cd-ff53-4b0d-ab7e-a68c1497c4c6","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"94759fce-692f-4779-b5f3-fce5c58f242c","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]},{"id":"27658163-a479-432f-a192-dbed286beb3e","tags":[{"product":null,"links":null,"id":"4d7b6a40-ab32-4c71-a381-58f3ffd2653e","name":"new","color":"#ed7422","productId":"d699a6af-e150-4da3-ab30-25fd97934601"}]}]
You could use PI
and E
identifiers for arguments of Math functions or in other expressions.
Returns the absolute value of a specified number.
Syntax
Abs(number
)
Arguments
number
- a number for which you want to return the absolute valueExamples
You can use the following expression to return the absolute value of the difference between the NetSales
and ProjectedSales
fields.
{Abs(NetSales - ProjectedSales)}
Returns the angle in radians whose cosine is the specified number.
Syntax
Acos(number
)
Arguments
number
- a number between -1 and 1, inclusive, representing a cosineExamples
You can use the following expression to return the angle whose cosine is -0.5
{Acos(-0.5)}
Returns the angle in radians whose sine is the specified number.
Syntax
Asin(number
)
Arguments
number
- a number between -1 and 1, inclusive, representing a sineExamples
You can use the following expression to return the angle whose sine is 0.77
{Asin(0.77)}
Returns the angle in radians whose tangent is the specified number.
Syntax
Atan(number
)
Arguments
number
- a number between -1 and 1, inclusive, representing a tangentExamples
You can use the following expression to return the angle whose tangent is -0.234
{Atan(-0.234)}
Returns the angle in radians whose tangent is the quotient of two specified numbers.
Syntax
Atan2(y
, x
)
Arguments
y
- The y coordinate of a point.x
- The x coordinate of a point.Examples
You can use the following expression to return the angle whose tangent is the quotient of (-1,-2)
{Atan2(-1, -2)}
Produces the full product of two 32-bit numbers.
Syntax
BigMul(a
, b
)
Arguments
a
- The first number to multiply.b
- The second number to multiply.Examples
You can use the following expression to return the full product of the UnitPrice
and Quantity
fields.
{BigMul(UnitPrice, Quantity)}
Returns the smallest integral value greater than or equal to the specified number.
Syntax
Ceiling(number
)
Arguments
number
- a number to return the "ceiling" forExamples
You can use the following expression to return the "ceiling" of 5.789
{Ceiling(5.789)}
Returns the cosine of the specified angle.
Syntax
Cos(angle
)
Arguments
angle
- an angle in radians.Examples
You can use the following expression to return the cosine of the PI/2
angle.
{Cos(PI / 2)}
Returns the hyperbolic cosine of the specified angle.
Syntax
Cosh(angle
)
Arguments
angle
- an angle in radians.Examples
You can use the following expression to return the hyperbolic cosine of PI
angle.
{Cosh(PI)}
Returns e
(Euler's number) raised to the specified power.
Syntax
Exp(number
)
Arguments
number
- a number specifying a power.Examples
You can use the following expression to return e
raised to five.
{Exp(5)}
Removes the fractional part of a number and returns the resulting integer value.
Syntax
Fix(number
)
Arguments
number
- a number for which you want to return the integer portion.Examples
You can use the following expression to return the integer portion of 101.789
{Fix(101.789)}
Returns the smallest integral value less than or equal to the specified number.
Syntax
Floor(number
)
Arguments
number
- a number to return the "floor" forExamples
You can use the following expression to return the "floor" of 15.789
{Floor(15.789)}
Returns the remainder resulting from the division of a specified number by another specified number.
Syntax
IEEERemainder(a
, b
)
Arguments
a
- a dividend.b
- a divisor.Examples
You can use the following expression to return the remainder from the 100/89
division.
{IEEERemainder(100, 89)}
Returns the logarithm of the specified number.
Syntax
Log(number
)
Arguments
number
- a number for which you want to return the logarithm.Examples
You can use the following expression to return the logarithm of 78
{Log(78)}
Returns the base 10 logarithm of the specified number.
Syntax
Log10(number
)
Arguments
number
- a number for which you want to return the base 10 logarithm.Examples
You can use the following expression to return the base 10 logarithm of 1000
{Log10(1000)}
Returns a specified number raised to the specified power.
Syntax
Pow(x
, y
)
Arguments
x
- a number to be raised to a power.y
- a number that specifies a power.Examples
You can use the following expression to return the result of 10
raised to 5
{Pow(10, 5)}
Rounds a decimal number to the nearest integral value and rounds midpoint values to the nearest even number.
Syntax
Round(number
)
Arguments
number
- a number which you want to roundExamples
You can use the following expression to return the rounding result of PI
{Round(PI)}
Returns an integer that indicates the sign of a number
-1
means a number is less than zero.0
means a number is equal to zero.1
means a number is greater than zero.Syntax
Sign(number
)
Arguments
number
- a number for which you want to return the signExamples
You can use the following expression to return the sign of -234
{Sign(-234)}
Returns the sine of the specified angle.
Syntax
Sin(angle
)
Arguments
angle
- an angle in radians.Examples
You can use the following expression to return the sine of the PI/4
angle.
{Sin(PI / 4)}
Returns the hyperbolic sine of the specified angle.
Syntax
Sinh(angle
)
Arguments
angle
- an angle in radians.Examples
You can use the following expression to return the hyperbolic sine of the PI
angle.
{Sinh(PI)}
Returns the square root of a specified number.
Syntax
Sqrt(number
)
Arguments
number
- a number for which you want to return the square root.Examples
You can use the following expression to return the square root sine of 144
{Sqrt(144)}
Returns the tangent of the specified angle.
Syntax
Tan(angle
)
Arguments
angle
- an angle in radians.Examples
You can use the following expression to return the tangent of the PI/4
angle.
{Tan(PI / 4)}
Returns the hyperbolic tangent of the specified angle.
Syntax
Tanh(angle
)
Arguments
angle
- an angle in radians.Examples
You can use the following expression to return the hyperbolic tangent of the PI/3
angle.
{Tanh(PI / 3)}
Calculates an integral part of a number.
Syntax
Truncate(number
)
Arguments
number
- a number to truncateExamples
You can use the following expression to truncate 123.564
{Truncate(123.654)}