Standard functions: Difference between revisions
From Planfix
| Line 40: | Line 40: | ||
*[[TEXT Function]] | *[[TEXT Function]] | ||
*[[POWER function|POWER Function]] | *[[POWER function|POWER Function]] | ||
*[[MOD function]] | *[[MOD function|MOD Function]] | ||
*[[ABS function]] | *[[ABS function|ABS Function]] | ||
*[[SQRT function]] | *[[SQRT function|SQRT Function]] | ||
*[[SIN function]] | *[[SIN function|SIN Function]] | ||
*[[COS function]] | *[[COS function|COS Function]] | ||
*[[RADIANS function]] | *[[RADIANS function|RADIANS Function]] | ||
*[[PI function]] | *[[PI function|PI Function]] | ||
*[[ASIN function]] | *[[ASIN function|ASIN Function]] | ||
*[[ACOS function]] | *[[ACOS function|ACOS Function]] | ||
*[[RAND function]] | *[[RAND function|RAND Function]] | ||
*[[RANDBETWEEN function]] | *[[RANDBETWEEN function|RANDBETWEEN Function]] | ||
==Date functions== | ==Date functions== | ||
Revision as of 08:19, 9 February 2024
Planfix supports standard operations for formulas in reports and calculated fields. At the moment, you can use the following operations and functions in formulas:
Standard operations
- addition +
- subtraction -
- multiplication *
- division /
- parentheses ( )
Functions
Line functions
- CONTAIN Function
- SUBSTITUTE Function
- LEFT Function
- RIGHT Function
- MID Function
- CHAR Function
- FIND Function
- SEARCH Function
- MD5 Function
- ENCODEURL Function
- UPPER Function
- LOWER Function
- PROPER Function
- REGEXPFIND Function
- BASE64ENCODE Function
Number functions
- ROUND Function
- MROUND Function
- ROUNDUP Function
- ROUNDDOWN Function
- TEXT Function
- POWER Function
- MOD Function
- ABS Function
- SQRT Function
- SIN Function
- COS Function
- RADIANS Function
- PI Function
- ASIN Function
- ACOS Function
- RAND Function
- RANDBETWEEN Function
Date functions
- NOW Function
- CNOW Function
- DATE Function
- TIME Function
- EDATE Function
- DATEVALUE Function
- TIMEVALUE Function
- WEEKDAY Function
- WEEKNUM Function
- DAY Function
- MONTH Function
- YEAR Function
- HOUR Function
- MINUTE Function
- SECOND Function
- EMONTH Function
- ISWORKDAY Function
- WORKDAY Function
- NETWORKDAYS Function
Additional