Round off of decimals in SPS 8 and SPS 10

[Former Member]

Hi,

We have created a computed column Column C = (Column A/Column B) with data type ‘DOUBLE’  in a calculation view in SPS 8 and we are getting more than 12 values after the decimal point as shown below.

        SPS 8 output    

                                                                                                                               Column C                                                                                            

When the same view is moved to SPS 10, for the same column, the decimal values got round off to 5 values as shown below.

     SPS 10 output

                                                                                                                            Column C

Kindly let us know

1. Why this is happening
2. Are there any configuration changes needs to be done to resolve this in SPS 10.

[Former Member]

You can simply change it to data type Decimal and set the number of decimal you need. that will take care of it.

and if you want to round, then use round Mathematical function round((Column A/Column B),x)

and x would be the number of digits from the left that you would like to round.

hope this help.

[former_member200930]

Hi,

You can fix this by using following formula for calculated column

round((column A / column B),2)

I hope, this will help you.

-Vikram Divekar

[Former Member]

Are you able to resolve the issue? We're also seeing same issue after upgrade. What is the solution?

Thanks,

Milind

[Former Member]

No,not yet.We are facing the same issue when migrated from SPS10 to HCP also.

Please let us know the solution if you or your team gets it.