Domo Changing Values

damen
damen Contributor
in Connectors

Anyone know how to make sure domo doesnt change values in my uploaded excel file?

image.png image.png

Clearly, everyone one of the values in the excel file has .XX and nothing more. Domo is adding values to the upload.

How do I get this to stop?

If this helps, feel free to agree, accept or awesome it!

Tagged:

Best Answer

  • DashboardDude
    DashboardDude Coach
    Answer ✓

    @damen I would just make a Beast mode calculated field where you round everything to 2 decimal places after your upload. That formula is ROUND(`P&l Payment Amont`,2)

    Circle.png

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter

Answers

  • DashboardDude
    DashboardDude Coach
    Answer ✓

    @damen I would just make a Beast mode calculated field where you round everything to 2 decimal places after your upload. That formula is ROUND(`P&l Payment Amont`,2)

    Circle.png

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter

  • snichols
    snichols Member

    I had the same issue with Domo changing the scale like that when using DECIMAL data type in workbench. You can also use the round function in a formula tile via ETL to accomplish the same thing.

Categories