This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Cacluclation of an expression is different from expecting result

Posted on 12-29-2020 03:04 PM
BOTFORCE
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

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 Solved
0 3 245
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
BOTFORCE
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

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

View solution in original post

Jump to Solution
3 REPLIES 3
Top Labels in this Space