Skip to main content
jahnavi
Contributor ⭐️⭐️⭐️⭐️⭐️
Sep 11, 2017 10:49 AM UTC
Solved

Importing decimal values

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?
sai_ram
sai_ramAnswer
Expert ⭐️⭐️
Sep 13, 2017 9:32 AM UTC
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.

7 replies

lakshmi_chaitanya
Helper ⭐️⭐️⭐️
Sep 11, 2017 4:24 PM UTC
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
Translate
jahnavi
jahnaviAuthor
Contributor ⭐️⭐️⭐️⭐️⭐️
Sep 12, 2017 10:33 AM UTC
Thanks Lakshmi this helped.
Translate
jahnavi
jahnaviAuthor
Contributor ⭐️⭐️⭐️⭐️⭐️
Sep 12, 2017 10:35 AM UTC
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
Translate
jahnavi
jahnaviAuthor
Contributor ⭐️⭐️⭐️⭐️⭐️
Sep 12, 2017 11:09 AM UTC
Note : I have enabled decimal view at c360 and summary widget as well
Translate
lakshmi_chaitanya
Helper ⭐️⭐️⭐️
Sep 12, 2017 12:33 PM UTC
Hi Jahnavi,

Are you able to view the decimals now?

Thanks,
Lakshmi
Translate
sai_ram
sai_ramAnswer
Expert ⭐️⭐️
Sep 13, 2017 9:32 AM UTC
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.

Translate
jahnavi
jahnaviAuthor
Contributor ⭐️⭐️⭐️⭐️⭐️
Sep 18, 2017 6:39 AM UTC
yes thank you
Translate