Skip to main content
Solved

Importing decimal values

  • September 11, 2017
  • 7 replies
  • 84 views

jahnavi
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️⭐️⭐️
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?

Best answer by sai_ram

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 ⭐️⭐️⭐️
  • September 11, 2017
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

jahnavi
Forum|alt.badge.img
  • Author
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • September 12, 2017
Thanks Lakshmi this helped.

jahnavi
Forum|alt.badge.img
  • Author
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • September 12, 2017
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

jahnavi
Forum|alt.badge.img
  • Author
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • September 12, 2017
Note : I have enabled decimal view at c360 and summary widget as well

lakshmi_chaitanya
  • Helper ⭐️⭐️⭐️
  • September 12, 2017
Hi Jahnavi,

Are you able to view the decimals now?

Thanks,
Lakshmi

sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • Answer
  • September 13, 2017
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.


jahnavi
Forum|alt.badge.img
  • Author
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • September 18, 2017
yes thank you