Solved

Importing decimal values

  • 11 September 2017
  • 7 replies
  • 64 views
jahnavi
Rank
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

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

Are you able to view the decimals now?

Thanks,
Lakshmi
sai_ram
Rank
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.

jahnavi
Rank
Userlevel 6
Badge
yes thank you

Reply


Terms & ConditionsCookie settings