@TRUNCATE

Function

The @TRUNCATE() function removes the fractional part of expression, returning the integer.

Syntax

@TRUNCATE (expression)

expression

Single member specification, function, variable name, or other numeric expression, which returns a numeric value.

Example

In the following example, Total Sales is calculated by (1) taking the sum of the values for Direct Sales and Other Sales and (2) truncating the summed values.

"Total Sales" = @TRUNCATE(@SUM("Direct Sales":"Other Sales"));

This example produces the following report:

                   Colas      New York     Actual
                      Jan       Feb       Mar
                      ===       ===       ===
Direct Sales        678.557   645.874   675.299
Other Sales         411.299   389.554   423.547

Total Sales        1089      1035      1098

See Also

@REMAINDER
@ROUND

Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.