FORMULA LANGUAGE


Examples: @Abs
1. This example returns 2.16.
2. This example returns 2.15 and 2.16 in a list.
3. This example returns 2.16 if the number in the field named Net is either 2.16 or -2.16.
4. This example returns 25 if Score1 = 50 and Score2 = 75, or if Score1 = 75 and Score2 = 50.
5. This formula, for a computed number field called numDays, uses @Abs to calculate the number of days between two dates, which are stored in time fields dateA and dateB. @Integer(dateA-dateB) returns the number of seconds between dateA and dateB, so the formula divides by 60*60*24 to get days. For example, if dateA is 08/11/95 and dateB is 09/22/95, the formula returns: 42.
See Also