Standard functions: Difference between revisions
From Planfix
No edit summary |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 92: | Line 92: | ||
*[[NETWORKDAYS Function]] | *[[NETWORKDAYS Function]] | ||
*[[TEXT Function #Formatting dates]] | *[[TEXT Function #Formatting dates]] | ||
*[[DATEINWORDS Function]] | |||
== Functions for variables with a set of values == | == Functions for variables with a set of values == | ||
*[[UNIQUE Function]] | *[[UNIQUE Function]] | ||
| Line 100: | Line 102: | ||
*[[JSONARRAY Function]] | *[[JSONARRAY Function]] | ||
== Functions available in document templates == | == Functions available in document templates == | ||
*[[SUM Function]] | |||
== Additional == | == Additional == | ||
*[[Function Nesting]] | *[[Function Nesting]] | ||
Latest revision as of 08:39, 24 March 2025
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 ()
- greater than >
- less than <
- equals =
- greater than or equal to >=
- less than or equal to <=
- not equal to !=
- raise to the power ^
- logical AND && -example
- logical OR || - example]
Functions
String functions
- CONTAIN Function
- CONCATENATE Function
- SUBSTITUTE Function
- LEFT Function
- RIGHT Function
- LEN Function
- MID Function
- CHAR Function
- FIND Function
- SEARCH Function
- MD5 Function
- SHA256 Function
- HMACMD5 Function
- HMACSHA256 Function
- ENCODEURL Function
- UPPER Function
- LOWER Function
- PROPER Function
- REGEXPFIND Function
- BASE64ENCODE Function
- GUID Function
- MD2HTML 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
- DATEONLY Function
- DATEDIF Function
- TIME Function
- EDATE Function
- DATEVALUE Function
- TIMEVALUE Function
- WEEKDAY Function
- WEEKNUM Function
- DAY Function
- MONTH Function
- QUARTER Function
- YEAR Function
- HOUR Function
- MINUTE Function
- SECOND Function
- ADDMINUTES Function
- ADDHOURS Function
- EOMONTH Function
- ISWORKDAY Function
- WORKDAY Function
- NETWORKDAYS Function
- TEXT Function #Formatting dates
- DATEINWORDS Function
Functions for variables with a set of values
Functions available in document templates
Additional