Calc: Formula

Formula based on other fields

Properties

• Type: Complex
• Groupable: No
• Show in lists: Yes
• Searchable: Yes
• Requires configuration: Yes

User interface

Field in show mode

Due to its nature this field has no special editing mode.

Configuration

[Description of configs]

Complex formulas

Calculated formulas syntax follows is compliant with JavaScript syntax.

Common operators

• Add: +
• Subtract: -
• Division: /
• Multiply: *
• Modulus: %
• Precedence: ( ... )

Mathematical functions

• Absolute: abs
• Minimum: max
• Maximum: min
• Power: pow
• Square root: sqrt
• Logarithms: log log10 exp
• Rounding: ceil floor round

Mathematical constants

• Pi: pi
• E: e

Support for statements

This feature is enabled starting from version 2366.

IF statement

Syntax used matches JavaScript inline IF statements.

To make the statement work make sure to add a space: before ), after (, before and after ? and :.

( Value1 Operator Value2 ? ValueIfTrue : ValueIfFalse )

• Test
  • First value or expression
  • Operator
    • Equal: =
    • Unequal: !=
    • Greater: > (>=)
    • Lesser: < (<=)
  • Second value or expression
• Result
  • TRUE value or expression
  • FALSE value or expression

Examples

Script code / specification

 var result;
 if ( [NUMBER1] >  [NUMBER2] ) {
       result = [NUMBER1] * 11;
 }
 else {
       result = [NUMBER3];
 }
 return result;

Expression to use in formula

( [NUMBER1] >  [NUMBER2] ? [NUMBER1] * 11 : [NUMBER3] )

Developer info

• FeltTypeID: 81
• SQL datatype: DECIMAL(20,4)
• Class name: FieldCalcFormula