This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided “as is” with no warranties.

Objective

This article is for users that would like to change their decimal data type to round off to their desired "rounding off value," as the value gets saved to the list view / back end database.

The K2 application provides two decimal places by default when the decimal SmartObject property is created.

 

Before You Begin

This KB is meant to provide the solution for K2 users running K2 Five. However, an additional solution/alternative is provided to also cover K2 users running K2 blackpearl 4.7

How-to Steps

In K2 Five, you can specify your desired rounding off when creating the SmartObject properties for the decimal data type as depicted below. This is still editable even after the views and forms are already generated.

Image

In K2 blackpearl 4.7 you will need to do the following

1. Create a custom database.
2. In a datatype decimal specify the desired rounding off value.
3. Create an SQL service instance.
4. Connect your SmartObject to your custom database.