Format Decimals Potential bug?

André Pinho

Solved

Question

Hi All,

Anyone else getting this problem, trying to format a decimal but being told it needs a decimal rather than text, but I am using a decimal data type:

05 Oct 2019

Daniël Kuhlmann

MVP

Solution

Hi André,

This is not a bug, fhe FormatDecimal returns the decimal value formatted as Text, just as the message at the bottom of your screen shot explains.

So you can not assign it to a parameter of type Decimal, it should be of data type Text.

Regards,

Daniel

05 Oct 2019

glenn michiels

A solution would be to wrap your code in a TextToDecimal() function.

Ex. TextToDecimal(FormatDecimal(Decimal,0,",","."))

Regards,
Glenn

07 Oct 2019

Daniël Kuhlmann

MVP

Btw, if you need currency formatting on input fields that this is a very nice component to handle that:

Check-out the demo app.

07 Oct 2019

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.