Standard functions

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

• FIELDISEMPTY Function
• IF Function
• AND Function
• OR Function

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

• UNIQUE Function
• SUM Function
• SUMIF Function
• TEXTJOIN Function
• COUNTIF Function
• JSONARRAY Function

Functions available in document templates

• SUM Function

Additional

• Function Nesting
• Variables in Text
• Functions in document templates
• Escaping quotes

Go To

• Reports: Formulas
• Types of custom fields