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 as per the conditions under 'where' and 'group by' clause. For example, sum of Purchase Order Header - Extended Report Amount.

  • Average of

    Average of an attribute selected and filtered as per the conditions under 'where' and 'group by' clause. For example, average of Purchase Order Header - Extended Report Amount.

  • Count of

    Count of an attribute selected and filtered as per the conditions under 'where' and 'group by' clause. For example, count of Purchase Order Header - Purchase Order IDs.

  • Maximum of

    Maximum value of an attribute selected and filtered as per the conditions under 'where' and 'group by' clause. For example, Maximum of Purchase Order Header - Extended Report Amount.

  • Minimum of

    Minimum value of an attribute selected and filtered as per the conditions under 'where' and 'group by' clause. For example, Minimum of Purchase Order Header - Extended Report Amount.

  • Absolute of

    Absolute values of an attribute selected and filtered as per the conditions under 'where' For example, Absolute of Purchase Order Header - Extended Report Amount.

  • Variance of

    Variance of an attribute selected and filtered as per the conditions under 'where' and '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 as per the conditions under 'where'clause.

• Math Operators
  • Addition operator
  • Subtraction operator
  • Multiplication operator
  • Division operator
  • Modulo operator
• Brackets
  • (.....) Brackets
  • ( Open bracket
  • ) Close bracket