Removes the fractional part of expression, returning the integer.
Syntax
@TRUNCATE (expression)
Parameter | Description |
---|---|
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