Cacluclation of an expression is different from expecting result

[BOTFORCE]

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

[LeventK]

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)

[BOTFORCE]

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

[BOTFORCE · Accepted solution]

Aaah, my bad! I used percentage instead of decimal for [Körperfett]. Sorry for bothering everyone.
Cheers,
Robert