Remove zeros to the right of the decimal point

AppSheet AppSheet Q&A
1

Hello people, good day. Does anyone know how to remove zeros to the right of the decimal point? Imagine that once I have a quantity of 10.3, but another time I have a quantity of 0.005.

If I show a number of zeros to the right of the comma it can lead to misinterpretation. For example, if the first quantity is 10.3, it will be displayed as 10,300 and that lends itself to understanding that the number can be ten thousand three hundred when it is 10.3

I would like zeros not to appear if they do not provide a value at the end of the result, but I would like them to be taken into account since in many cases they are necessary.

1 Like
2

Hello @Gustavo_Eduardo , you could try using the TEXT() function, apparently it can help by using both “,” and “.” for displaying your numbers, here’s the example it shows in the help page:

Rafael_ANEICPY_0-1653399892250.png

2 Likes
3

What do you want to do with the case of 10/3, result would be 3.33333333333333…?

1 Like
4

Hello, how are you @Koichi_Tsuji ? In general, in the configuration of the field you choose how many decimal places the value written there will have. I would like to have three decimal places to the right of the decimal point; however, there are cases where you would prefer not to have three decimal places. These cases are those in which only zeros appear to the right of the decimal. I have NEVER divided 10/3 but I am writing a decimal 10.3 (103/10) What I want is that I don’t get the zeros on the right

5

So you mean max 3 decimals, or less?

6

Hi @Rafael_ANEIC-PY I’m going to try as you say, with a text function, but I’m going to suggest to appsheet the possibility of adding a feature where it can be checked (“omit trailing zeros”)

7

Probably, this expression (for new VC, anchoring your decimal column with 3 digits max) will solve the issue.

ifs(
endswith(text([Decimals]),“000”),left(text([Decimals]),len(text([Decimals]))-3),
endswith(text([Decimals]),“00”),left(text([Decimals]),len(text([Decimals]))-2),
endswith(text([Decimals]),“0”),left(text([Decimals]),len(text([Decimals]))-1),
true,[Decimals]
)

4 Likes
8

[Decimals] column is normal column, set to decimal type with max 3 digits.

Show this column with context(viewtype)=Form.

2 Likes
9

Sure. What I ask is how to remove zeros to the right of the decimal point if they are not useful?

10

You already have the solution. Please use the expression Koichi provided.

2 Likes
11

Recién lo veo @Koichi_Tsuji , me lo hizo notar @Joseph_Seddik agradezco su solución! Un saludo!! Pienso que con 3 decimales como máximo está perfecto

1 Like
12

Gracias Joseph por hacermelo notar, ahí la aplicaré.

1 Like
13

Muchas gracias Rafael. Por ahora tome la soluciĂłn de Koichi

14 
IF(
  (([Decimal] - FLOOR([Decimal])) = 0.0),
  TEXT(FLOOR([Decimal])),
  TEXT([Decimal])
)
4 Likes
15

Thanks you Steve!!!

1 Like
16

Staying on topic, guys. Does anyone know a formula to count the decimal places that a number has?

17

LEN(TEXT([number] - FLOOR([number]))) - 2

But I’m not sure whether AppSheet takes into account more than two decimal digits anyway.

2 Likes
18

Gracias Joseph! si funciona perfecto, de paso te comento que si tiene en cuenta el resto de decimales porque el resultado es 3 y yo tengo 3 decimales! un abrazo

1 Like
19

Perfecto, gracias por la informaciĂłn :slightly_smiling_face:

1 Like