Math not working as expected

I am trying to create a virtual column that stores a value based on percentage of another value.
When I put in the formula it works at first but then the value gets reset after a sync.
To test this bug I use this formula (1/10)*200. It is supposed to be 200 but It always shows 0

Solved Solved
0 2 287
1 ACCEPTED SOLUTION

Instead of using integers, use decimals like (1.0/10.0)*200.0 and then the result should be correct like 20.

View solution in original post

2 REPLIES 2

Instead of using integers, use decimals like (1.0/10.0)*200.0 and then the result should be correct like 20.

Thank you. Your solution worked.

Top Labels in this Space