Math rule conditions

A math rule is required when you need computed data. A math rule condition can have:

  • Math function: These are the math functions that you can select for creating a rule condition:
    • Sum of

      Summation of the attribute selected based on the conditions in the Where/Group By clause. For example, sum of Purchase Order Header - Extended Report Amount.

    • Average of

      Average of an attribute selected and filtered based on the conditions in the Where/Group By clause. For example, average of Purchase Order Header - Extended Report Amount.

    • Count of

      Count of an attribute selected and filtered based on the conditions in the Where/Group By clause. For example, count of Purchase Order Header - Purchase Order IDs.

    • Maximum of

      Maximum value of an attribute selected and filtered based on the conditions in the Where/Group By clause. For example, Maximum of Purchase Order Header - Extended Report Amount.

    • Minimum of

      Minimum value of an attribute selected and filtered based on the conditions in the Where/Group By clause. For example, Minimum of Purchase Order Header - Extended Report Amount.

    • Absolute of

      Absolute values of an attribute selected and filtered based on the conditions in the Where clause. For example, Absolute of Purchase Order Header - Extended Report Amount.

    • Variance of

      Variance of an attribute selected and filtered based on the conditions in the Where/Group By clause. For example, Variance of Purchase Order Header - Extended Report Amount.

    • Date difference of

      Difference between two date attributes of same or different objects selected and filtered based on the conditions in the Where clause.

  • Math Operators
    • Addition operator
    • Subtraction operator
    • Multiplication operator
    • Division operator
    • Modulo operator
  • Brackets
    • (.....) Brackets
    • ( Open bracket
    • ) Close bracket
Note: When creating a math rule, you can add multiple groups. By default, the operator OR is used between these groups. This default operator cannot be changed.