How to save a rounded decimal value to a SQL database table

Topic

This article will cover how to save a rounded decimal value to a SQL database table. 

For SmartBox SmartObjects, this can be done by specifying the Decimal Places on the Decimal property as per the image below:

Instructions

In this example, the Price Text Box holds the decimal value:

1. Create a new Expression.
2. Use the Round Up inline function found under Operators > Mathematical and set it up as per the image below. The second parameter (eg. 2) depends on the scale (number of decimal places) required:

    

3. Click on OK to save the Expression.
4. Go to the Rules tab and open the rule which calls the SQL SmartObject to save the value to your database.
5. Before the Create/Update method is called, add a transfer data action:

    

6. Map the RoundUp expression created to the Price Text Box: 

Test

1. 1. Run the view and type in 4.555 on the Price Text Box:

       

   2. Click outside the Price Text Box so it changes to 4.56:

       

   3. Click on the Create button and the rounded off value should be stored in the database:

Related Links

https://community.nintex.com/t5/How-To/How-to-save-decimal-value-and-make-it-round-off-to-the-desired/ta-p/126285 

https://help.nintex.com/en-US/k2five/userguide/5.4/default.htm#Create/SmartObjects/SmartBox.htm