Truncate to Whole Number
The Truncate to Whole Number function truncates values in a time series or paired
data set to the nearest whole number. For example:
10.99 is truncated to 10.
10.499 is truncated to 10.
-10.001 is truncated to -10.
-10.999 is truncated to -10.
The x-values in paired data sets are unaffected by the function, only the y-value data are truncated. For time series data sets, missing values are kept missing.
To truncate values in time series or paired data sets to the nearest whole number: