UltraCalcFunctionTrunc Class

Truncates the fractional portion of a numeric value to produce an integer.

Syntax

Visual Basic

'Declaration
 
Public Class UltraCalcFunctionTrunc 
   Inherits BuiltInFunctionBase

C#

public class UltraCalcFunctionTrunc : BuiltInFunctionBase 

Remarks

TRUNC(value, number_of_digits)

Value is a numeric value or reference to a numeric value that you want to truncate.

Number_of_digits specifies the precision at which truncation should occur. By default, truncation occurs zero places right of the decimal point which will produce an integer.

Truncation always discards the fractional value, causing the Value to move closer to zero (whether it was positive or negative before the truncation). It differs from the ROUND() function in that the value always changes to a lesser value.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2