Solved

Importing decimal values

  • 11 September 2017
  • 7 replies
  • 64 views

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

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
Badge
Thanks Lakshmi this helped.
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
Badge
Note : I have enabled decimal view at c360 and summary widget as well
Hi Jahnavi,



Are you able to view the decimals now?



Thanks,

Lakshmi
Userlevel 7
Badge +1
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.

Badge
yes thank you

Reply