Domo Changing Values

Options
damen
damen Contributor

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

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
    Answer ✓
    Options

    @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)

    John Le

    You're only one dashboard away.

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

Answers

  • DashboardDude
    Answer ✓
    Options

    @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)

    John Le

    You're only one dashboard away.

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

  • snichols
    snichols Member
    Options

    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.