zach.puckett

Rounding Numbers with Nintex Forms

Blog Post created by zach.puckett Support on Oct 21, 2014

Thanks to Sean Fiene for assistance.

 

Question: I would like to input a number into a “Single Line Textbox” and have the results show only two decimal places on the View mode of the form.

 

Step 1:

Create a Nintex Form and add a ‘Single Line Textbox’ configured with a Data type of ‘Decimal’ and name of “RoundNumber”

1.png

Step 2:

Add a rule of type “Formatting” with a condition of “Is display Mode” and “Hide”

2.png

Formula builder for condition:

3.png

Step 3:

Under Nintex Forms Ribbon bar choose “Form Variables”

4.png

Click ‘Add’ and create a new variable that includes a formula of ‘Round’ referencing the single line text column of “RoundNumber” and the number of decimal places needed.

Example: Round(roundNumber, 2)

5.png

6.png

Step 4:

Add a calculated Value control to the form with formula referencing the Forms Variable you created in step 3, in my example it is named “Rounding”.

7.png

Step 5:

Create a rule on the Calculated Value Control with formatting condition of “not(Is Display Mode” and choose ‘Hide’

8.png

Step 6:

Align the Single Line Textbox and Calculated value controls on top of each other and publish the form.

 

Results:

Edit Mode:

9.png

View Mode:

10.png

Outcomes