Hi all,
I have an issue and I have no clue why Appsheet is calculating this different from excel:
([Körpergewicht] * DECIMAL((100.00 - [Körperfett]) / 100.00))
In this formula above the Körperfett = 16,9 and Körpergewicht = 81,4 and expected result from this formula is 67,6, but Appsheets result is: 81,3.
I have no Idea how Appsheet is calculating this and what I am doing wrong. If i put the formula in the sheet, it is calculating it correctly.
Thx.
Robert
Solved! Go to Solution.
Aaah, my bad! I used percentage instead of decimal for [Körperfett]. Sorry for bothering everyone.
Cheers,
Robert
Hello Levent,
as you can see in my screenshot, it is still calculating wrong (81,3 instead of 67,6)…what do you think could be a reason?
Does the row order maybe matters here?
BR. Robert
Aaah, my bad! I used percentage instead of decimal for [Körperfett]. Sorry for bothering everyone.
Cheers,
Robert
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |