...
| Addition | + |
|---|---|
| Subtraction | - |
| Division | / |
| Multiplication | * |
| Absolute Value | ABS() |
| Ceiling | CEILING(),CEIL() |
| Floor | FLOOR() |
| Natural logarithm | LN() |
| Modulus | MOD() |
| Power | POWER() |
| Square Root | SQRT() |
...
Computing New Variables
Variables can be computed using the following syntax in the cols parameter, variableName:computationExpression. The following will show you practical examples for a number of the supported operations described above.
Code Block title Addition httphttp://{host}/rds/api/catalog/{collection}/{view}/select?cols=newVar:Var1+Var2
Code Block title Multiplication httphttp://{host}/rds/api/catalog/{collection}/{view}/select?cols=newVar:Var1*Var2
Code Block title Square Root httphttp://{host}/rds/api/catalog/{collection}/{view}/select?cols=newVar:SQRT(Var1)