Calculated Fields


Calculated fields will always be up-to-date since calculations will be run automatically every time when you change the value of any field that is a part of the formula and they help you maintain data integrity.

Key Features

  • User-friendly interface to create even complex calculated fields
  • Access cross-module fields (Parent & Child modules) using pre-defined table relationships
  • Formulas can consist of values from other fields, constants, and the results of other formulas or functions
  • Extensive function library with more than 200 functions (String, Date/Time, Number, Arithmetic etc) and supports complex functions
  • Group functions (Count, Sum, Max, Min, Avg) on child modules
  • Access to Global variables (Exchange rates, Date formats etc), Company constants, System fields and User/Session fields
  • 1000+ pre-defined Calculated fields across various modules
  • Ability to copy, edit pre-defined Calculated fields and restore

Examples

  1. 1000+ pre-defined Calculated fields across various modules
  2. Ability to copy, edit pre-defined Calculated fields and restore