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
View originalImporting decimal values
Userlevel 6
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?
Eg: 0.876 is rounded to 0
Note I am trying manual import and not from S3
How do I import decimal values?
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
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
Userlevel 6
Thanks Lakshmi this helped.
Userlevel 6
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
Userlevel 6
Note : I have enabled decimal view at c360 and summary widget as well
Userlevel 4
Hi Jahnavi,
Are you able to view the decimals now?
Thanks,
Lakshmi
Are you able to view the decimals now?
Thanks,
Lakshmi
Userlevel 7
+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.
Please let us know if you still face issue after the below configuration.
Userlevel 6
yes thank you
Reply
Register for Pulse Encore 2023
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Login to the community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.