Domo Changing Values

damen Contributor

June 2024 in Connectors

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:

• Connectors

0

Best Answer

• 

  DashboardDude Coach

  June 2024 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)

  

  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

  0

Answers

• 

  DashboardDude Coach

  June 2024 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)

  

  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

  0
• 

  snichols Member

  June 2024

  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.

  0

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.

Sign In