FORMULA LANGUAGE
Examples: @Abs
1. This example returns 2.16.
@Abs(2.16)
2. This example returns 2.16 if the number in the field named Net is either 2.16 or 2.16.
@Abs(Net)
3. This example returns 25 if Score1 = 50 and Score2 = 75, or if Score1 = 75 and Score2 = 50.
@Abs(Score1 - Score2)
4. 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.
@If( numDays = ""; 0; @Abs( @Integer( dateA - dateB ) / (60 * 60 * 24 ) ) )
Véase también
@Abs
Glosario
¿Desea opinar sobre la
Ayuda
o sobre la
utilidad del producto
?
Ayuda sobre la Ayuda
Todo el contenido de la Ayuda
Glosario