Removes the fractional part of expression, returning the integer.


@TRUNCATE (expression)
Parameter Description


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


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