+5Is it possible to change the # of decimal places in a drill down in a horizon analytics report? Currently I have 5 decimal places and I can’t figure out how to reduce to just 2 places.
Also, I miss the days where currency values were represented with a $ instead of “USD”. Any chance of that being an option?
Best answer by jessica_owens
It’s a SFDC Account field, so I couldn’t adjust the default in Data Management.
I did however end up fixing it. I added the field to the show me in the report, then used the field settings gear icon to change the decimal places for that field. Then I removed the field from the show me (since I didn’t need it there - just the drill down) and it appeared in the drill down with only 2 decimal places.
Hopefully this fix sticks and helps others if they run into a similar problem! Thanks for the help!
+5Hi Jessica, the USD thing would be a product-related question, so I’ll defer that question. As for the decimals, there should be a gear icon next to your numerical and currency fields. Click that icon, and you’ll see that you can adjust the amount of decimal points.
+5Hi Spencer! I’m not able to find a gear icon in the drill down for this field. This field is not in the show me or the group by sections, it’s only just added in the drill down part of the report for more info for the team.
+5Interesting. Perhaps you need to go to Data Management and see if you can adjust what the default amount of decimals are?
+5It’s a SFDC Account field, so I couldn’t adjust the default in Data Management.
I did however end up fixing it. I added the field to the show me in the report, then used the field settings gear icon to change the decimal places for that field. Then I removed the field from the show me (since I didn’t need it there - just the drill down) and it appeared in the drill down with only 2 decimal places.
Hopefully this fix sticks and helps others if they run into a similar problem! Thanks for the help!
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
