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

    Let me make you the me of your organization for Domo

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

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

    Let me make you the me of your organization for Domo

    Click here for more video solutions: https://www.dashboarddudes.com/pantry

  • 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