Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Abs(number)

number - any numeric 

 or 

number, time

Returns the absolute value (a positive number) of number. For example, if a negative 

number appears in a field, the Abs function removes the minus sign and changes it to a 

positive value.

Abs(-123) returns 

.

Abs(PriceDifference) returns the positive value of the number in the PriceDifference 

field.

Abs(TargetDate - ActualDate) returns a positive value for the number of days 

difference between the values in TargetDate and ActualDate.

Ceiling(number)

number - any numeric 

 or 

number

Returns number rounded up to the next integer.

Ceiling(1.25) returns 

.

Ceiling(-1.25) returns 

.