Looking for an Appsheet function

[KyleWick]

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!!!!

[Markus_Malessa · Accepted solution]

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

[KyleWick]

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