POWER has invalid Inputs

[BOTFORCE]

Hi everyone,

I am trying to calculate the bodyfat%, but the expression (see below) is not working. I get the error message: POWER has invalid inputs. Anyone can help me here?

Thx Robert

0.483*((7.811*POWER([Körpergewicht],-0.288))*(0.304*POWER([Körpergröße],0.362))*POWER((ABS([SUMME]-((11.278*POWER([Körpergröße],-0.725))*POWER([Körpergewicht],0.575)+40)),0.5)))+(-0.006)

[LeventK · Accepted solution]

You have redundant paranthesises:

0.483*
(
	(
		7.811*POWER([Körpergewicht],-0.288)
	)*
	(
		0.304*POWER([Körpergröße],0.362)
	)*
	POWER(
		ABS(
			[SUMME]-((11.278*POWER([Körpergröße],-0.725))*POWER([Körpergewicht],0.575)+40)
		)
		,0.5
	)
)+
(-0.006)

[BOTFORCE]

LeventK:

0.483*
(
	(
		7.811*POWER([Körpergewicht],-0.288)
	)*
	(
		0.304*POWER([Körpergröße],0.362)
	)*
	POWER(
		ABS(
			[SUMME]-((11.278*POWER([Körpergröße],-0.725))*POWER([Körpergewicht],0.575)+40)
		)
		,0.5
	)
)+
(-0.006)

Thx Levent,

that was it!!
BR. Robert

[LeventK]

@Robert
You can also shorten your expression:

(
	1.146904752*
	POWER([Körpergewicht],-0.288)*
	POWER([Körpergröße],0.362)*
	POWER(
		ABS(
			[SUMME]-((11.278*POWER([Körpergröße],-0.725)*POWER([Körpergewicht],0.575))+40)
		)
		,0.5
	)
)
+
(-0.006)

[BOTFORCE]

Hi Levent,

sorry for bothering you again. 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, 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.

In the meantime i created this topic: Cacluclation of an expression is different from expecting result

Thx.
Robert

[LeventK]

@Robert
It seems it’s calculating correctly:

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)