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.
|