Trunc

How to Use the Power Fx TruncĀ  Function in Power Apps

What is the Trunc Function?

The Trunc function is used to truncate a decimal number to a specified number of digits after the decimal point. For example, Trunc(3.14159, 2) returns 3.14. The first argument is the number you want to truncate, and the second argument is the number of digits after the decimal point that you want to keep.

Using the Trunc Function in Power Apps

To use the Trunc function in Power Apps, you will first need to create a formula in the formula bar. Here’s an example of how to use the Trunc function to truncate a decimal number in Power Apps:


Trunc(Value(TextBox1.Text), 2)


In this example, TextBox1 is the name of the text box that contains the decimal number you want to truncate. The Value function is used to convert the text in the text box to a number that can be truncated. The second argument of the Trunc function is the number of digits after the decimal point that you want to keep.

Use Cases for the Trunc Function

The Trunc function can be used in a wide range of scenarios. Here are some examples:

Financial Applications

In financial applications, it's often necessary to truncate decimal numbers to a certain number of digits after the decimal point. For example, when calculating interest rates or loan payments, you may need to truncate the result to two decimal places. The Trunc function makes it easy to do this.

Data Analysis

When analyzing data, it's often necessary to round or truncate decimal numbers to a certain number of digits after the decimal point. This is especially true when dealing with large datasets. The Trunc function can be used to quickly and easily truncate decimal numbers in Power Apps.

User Input

When designing user input forms, it's important to ensure that users enter data in the correct format. For example, if you're designing a form for entering measurements, you may want to ensure that users enter decimal numbers with only two digits after the decimal point. The Trunc function can be used to automatically truncate the number to the correct format.

The Trunc function is a powerful tool in Power Apps that allows you to truncate decimal numbers to a specified number of digits after the decimal point. This function can be used in a wide range of scenarios, including financial applications, data analysis, and user input forms. By using the Trunc function in Power Apps, you can ensure that your calculations and data analysis are accurate and consistent.

Power Apps Training Courses by G Com Solutions (0800 998 9248)