How do I avoid decimals from being truncated while bringing data from Excel?
I have an Excel that has several measures that are percentages. The Excel is in a Box folder, so I am using the Box connector to bring the data to a Domo dataset. Everything works fine, except that the percentages get converted to decimal numbers (so, all are <1) and truncated to 2 decimals... so that is causing me issues when I use the SUM option for those percentages in my visualizations.
How do I fix it? Thanks!