Division Operation is not working

[alhazen]

I am not sure what happened, but it seems that the math expression, particularly the division operation, is not working at all

[AleksiAlkio]

Try with 1/2.0

[alhazen]

Hey, @AleksiAlkio, it works, but I don't think it's a solution. I tried using another number, like 7400/350, etc, but the calculation is completely wrong. It's not feasible to ask users to use a comma when inputting a number.

Do you know what happened? Thank you

[AleksiAlkio]

When you calculate with the division and both of them are numbers, the result is a number as well. If you need the result as a decimal, one of them needs to be a decimal like number/decimal or decimal/number. It doesn't mean the app user needs to add the decimal when filling the value, but your column type needs to be a decimal.

[alhazen]

Does it mean that if my calculation formula is as follows:

COUNT(
  FILTER(
    "subtask",
      AND(
        [task]=[_THISROW].[id],
        [status]="Closed"
        )
    )
  )
/
 COUNT(
  FILTER(
    "subtask",
        [task]=[_THISROW].[id]
    )
  )

I have to put a decimal formula before COUNT()?

DECIMAL(
  COUNT(....
  )
)

[AleksiAlkio · Accepted solution]

The best option is to write it like.. (1.0 * COUNT(..)) / COUNT(..)

[alhazen]

It makes sense, but I am still curious because I have never experienced something like this before

[AleksiAlkio]

This is how your app calculates it.
https://support.google.com/appsheet/answer/10106622?hl=en&sjid=11028410212436231873-EU#:~:text=%5BPr...

[alhazen]

Thank you @AleksiAlkio All clear now!