Filemaker Upgrade to FileMaker Pro 8.5 VLA Educational Tier 5 + Maintenance TJ065Z/A ユーザーズマニュアル
製品コード
TJ065Z/A
144 FileMaker Functions Reference
Abs
Format
Abs(number)
Parameter
number - any numeric
Data type returned
number, time
Description
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.
Examples
Abs(-123) returns
123
.
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
Format
Ceiling(number)
Parameter
number - any numeric
Data type returned
number
Description
Returns number rounded up to the next integer.
Examples
Ceiling(1.25) returns
2
.
Ceiling(-1.25) returns
-1
.