Importing decimal values

  • 1
  • Problem
  • Updated 10 months ago
  • Solved
  • (Edited)
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?
Photo of Jahnavi

Jahnavi, Champion

  • 1,938 Points 1k badge 2x thumb

Posted 10 months ago

  • 1
Photo of Lakshmi Chaitanya

Lakshmi Chaitanya, Product Manager

  • 1,684 Points 1k badge 2x thumb
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
Photo of Jahnavi

Jahnavi, Champion

  • 1,938 Points 1k badge 2x thumb
Thanks Lakshmi this helped.
Photo of Jahnavi

Jahnavi, Champion

  • 1,938 Points 1k badge 2x thumb
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
Photo of Jahnavi

Jahnavi, Champion

  • 1,938 Points 1k badge 2x thumb
Note : I have enabled decimal view at c360 and summary widget as well
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 9,960 Points 5k badge 2x thumb
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.
Photo of Lakshmi Chaitanya

Lakshmi Chaitanya, Product Manager

  • 1,684 Points 1k badge 2x thumb
Hi Jahnavi,

Are you able to view the decimals now?

Thanks,
Lakshmi
Photo of Jahnavi

Jahnavi, Champion

  • 1,938 Points 1k badge 2x thumb
yes thank you