Looking for an Appsheet function

AppSheet AppSheet Q&A
, , ,
1

Hey Guys,

Trying to build my first app but I’ve got a problem that I am trying to solve for hours.

I have got the current exchange rate of the USD for Thai Bhat (which is 0.002234) and when I am trying to use this exchange rate in calculations, the number() function rounds it up to 0 resulting the formulas arnt giving the right answer. Is there any way I can extract and use number below Zero for calculation? what format would support it?

Merci!!!

2

You could try DECIMAL() to see if that works.

1 Like
3

Thank you Markus. It worked. I had to convert both parameters into Decimal before multiplying. Cheers