Navigation menu

Go To

    *Reports: Formulas *Types of custom fields
Help Center

Standard functions

From Planfix
Jump to: navigation, search

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


Contents

  • 1 Functions
  • 2 Line functions
  • 3 Number functions
  • 4 Date functions
  • 5 Go To

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

Number functions

  • ROUND Function
  • MROUND Function
  • ROUNDUP Function
  • ROUNDDOWN Function
  • TEXT Function
  • POWER 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


Go To

  • Reports: Formulas
  • Types of custom fields
Retrieved from "http://planfix.com/help/index.php?title=Standard_functions&oldid=12930"