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
POWER has invalid Inputs Questions
@Robert It seems it’s calculating correctly: [image] Besides, your values are already a decimal, so you don’t need to wrap the 2nd argument with a DECIMAL() expression at all. Simply this will be sufficient [Körpergewicht] * (1 - [Körperfett] / 100.00)
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
