decimal to text

[Gustavo_Eduardo]

Hello everyone. I need appsheet to translate a decimal to text, but not give me all the figures, just two of them.

10/3=3.333333333333

I need

10/3=3.33

No more than that.

I also need to include that result in a text string with which I need to transform it to text.

Does anyone know how to do this? Thanks in advance.

[VOLODYMYR_TYROL]

Hi,  just run a test "TEXT(DECIMAL(10)/3)" and get "3.33"

[Gustavo_Eduardo]

Thanks, Of course, yes, that happens because you have configured your decimals with two figures. In my case I have more figures but I would like to transform the format so that it is only two figures. I'll leave the question open to see if someone can figure it out.

Cheers

[VOLODYMYR_TYROL · Accepted solution]

maybe this post going to help:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Write-decimal-numbers-with-2-digits-after-the-c...

ROUND( [Decimal] * 100) / 100.0

[Gustavo_Eduardo]

thank You