Math Functions
Mathematical functions are the predefined formulas that you can use to perform calculations including basic mathematical operations, rounding, finding smallest and larget numeric values on the specific source columns. With this transformation, you can quickly analyze the queried data in many forms.
| Transformation Types | Description |
|---|
| Custom Formula | Create your own mathematical expression that helps you to get your desired output |
| Minimum | Min can tell you what the smallest numeric value is in the given source columns |
| Maximum | Max can tell you what the largest numeric value is in the given source columns |
| Absolute | Absolute returns the (non-negative) value even if you apply this transformation on the source column that contains negative values |
| Rounding | Rounding returns a number rounded up to a given number of decimal places. |
| Floor | Round the number towards the zero |
| Ceiling | Round the number away from zero |
Supported Arithmetic Operators
| Operators | Descriptions |
|---|
| + | Addition |
| - | Subtraction |
| * | Multiplication |
| / | Division |
| % | Per cent |
| ^ | Exponentiation |
Supported Logical Operators
| Operators | Description |
|---|
| = | Assigment |
| == | Equals |
| != | Not equals |
| < | Less than |
| <= | Less than or equal to |
| > | Greater than |
| >= | Greater than or equal to |
| && | Boolean & And |
| II | Boolean or |
Supported Constant
| Constant | Description |
|---|
| e | The value e is equal to 70 digits |
| PI | The value PI is equal to 100 digits |
| TRUE | The value 1 |
| FALSE | The value 0 |
| NULL | The null value |