### Post

4 followers Follow

# Rounding of currency values

Hi, I have brought this up a while ago and now I really would need it: Rounding!! When I make calculation with currency fields it doesn't make sense to have 4 decimals… No way for a quick fix of this?!

Thanks,

Lars

Hey Lars!

Agree, would be nice. I will make sure to share your input with the rest of my team. Thanks for sharing your idea.

/Sara - Podio

Sara Høeg Højlund-Rasmussen 0 votes

Seconded,  AND (at least when a currency value is entered), breaking down figures into 3-digit numbers.

4 237 543€ is WAY easier to get than 4237543€

we are importing excel spreadsheets into podio for a production report and it converts the 2 decimals of Excel to the real value of the calculation so we get 22.4327865 kilos which is ridiculous for understanding. How can we get it to round to one or two decimals?

Daniel Strongin 0 votes

Hey Daniel,

Let us know in support  here and please include a few screenshots of the problem, then we can assist :)

//Sara - Podio

Sara Høeg Højlund-Rasmussen 0 votes

thanks Sara, but the problem was human.. my client had built the app using all text fields.

Daniel Strongin 0 votes

Really need this as well.  I have found how to round a calculated sum using  .toFixed(2)  but then there is no way to use those rounded sums in further calculations.

For Example..

If I have Field1 rounded and it equals "40.25", and I have Field2 rounded and it equals "20.50", I cannot then do @Field1+@Field2 and expect to get "60.75"...  Instead I get both values side-by-side..  "40.25,20.50"

??????  Is there anyway to do this?  Thanks.

Scott Anderson CCIM 0 votes