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 ( )

Functions

• IF Function
• AND Function
• OR Function

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

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

• Function Nesting

Go To

• Reports: Formulas
• Types of custom fields