Solved

Importing decimal values

  • 11 September 2017
  • 7 replies
  • 64 views

Userlevel 6
Badge
When I import ARR for my customers and if the values are in decimal it would then truncate the decimal values 
Eg: 0.876 is rounded to 0

Note I am trying manual import and not from S3

How do I import decimal values?
icon

Best answer by sai_ram 13 September 2017, 11:32

View original

7 replies

Userlevel 6
Badge
Thanks Lakshmi this helped.
Userlevel 4
Hi Jahnavi,

Make sure that you have set the number of decimals places appropriately.

Data Management > Select Object > Select the field > Set decimal places value for that field



You should now be able to see the decimal values in your data.

(P.S- You could just change the decimal places for the field in your object and you need not delete and re insert the data again)

Thanks and Regards,
Lakshmi
Userlevel 6
Badge
Also, I am applying aggregate "Sum" function on  this data but when I see the sum in C360 attributes section they are have values rounded up
Userlevel 6
Badge
Note : I have enabled decimal view at c360 and summary widget as well
Userlevel 4
Hi Jahnavi,

Are you able to view the decimals now?

Thanks,
Lakshmi
Userlevel 7
Badge +2
Hi Jahnavi, Hope you have enabled the configuration from Administration>>C360 Layouts>>Edit Summery Widget.
Please let us know if you still face issue after the below configuration.

Userlevel 6
Badge
yes thank you

Reply