Calculations

Element


Condition
Based on alpha elements. All conditions must be true before calculation will be performed.

Element1:Value1 or Value2 or Value3
and
Element2:Valuea or Valueb or Valuec or Valued
and
not Element3:ValueX or ValueY or ValueZ

Criteria
Based on numeric and date elements.

([Salary]<10000)&([Effective Date]Y[Date of Engagement]>10)
Means if salary is less than 10,000 and length of service is more than 10 years calculation will be performed

([Salary]<10000)|([Effective Date]Y[Date of Engagement]<1)
Means if salary is less than 10,000 or length of service is less than 1 year calculation will be performed

Criteria checks are performed after calculation but before value is updated. This means that the result of a calculation can influence criteria.

Calculation
Calculations are performed in the sequence of inner brackets to outer brackets and then left to right.
Valid Operators are
  • +  Add
  • -  Subtract
  • /  Divide
  • *  Multiply
  • %  Divide by 100
  • Q  Quotient (Eg. 13Q5 means the number of times 13 can be divided by 5 without a remainder. 13Q5 will result in 2)
  • R  Reminder (Eg. 13R5 means the remainder that is left after 13 has been divided by 5.  13R5 will have a remainder of 3)
  • Y  Years. The difference in completed years between 2 dates
  • M  Months. The difference in complete months between 2 dates
  • D  Days. The difference in completed days between 2 dates
  • h  Hours. The difference in completed hours between 2 dates
  • m  Minutes. The difference in completed minutes between 2 dates
  • s  Seconds. The difference in seconds between 2 dates
  • G  Greatest of. (Eg. 13G5 will return 13 as 13 is greater than 5, 13G13 will return 13 as the numbers are equal greatest)
  • L  Lesser of, (Eg. 13L5 will return 5 as 5 is less than 13, 13L13 will return 13 as the numbers are equal least)
  • >  Greater than. Returns 1 if true and 0 if false (Eg. 13>5 will return 1 as 13 is greater than 5 and 5>13 will return 0 as 5 is not greater than 13
  • <  Less than. Returns 1 if true and 0 if false (Eg. 13<5 will return 0 as 13 is not less than 5 and 5<13 will return 1 as 5 is less than 13
  • =  Equal to. Returns 1 if true and 0 if false (Eg. 13=5 will return 0 as 13 is not equal to 5 and 13=13 will return 1 as 13 is equal to 13
  • & AND. Returns 1 if both values are not equal to 0. (Eg. 1&1 returns 1 as both are  equal and 1&0 returns 0 as both are not true. 
  • | OR. Returns 1 if either or both of the values are not equal to 0. (Eg. 1&0 returns 1, 1&1 returns 1 and 0&0 returns 0.
  • All other values other than 0-9 and . is removed from calculations.
Usage of & (AND) and | (OR) is mostly used in combinations with >, < and = in the calculation criteria and very seldom in calculations itself.