POWER() Overhauled and (trivial) examples ad...

AppSheet AppSheet Q&A
1

POWER()

Overhauled and (trivial) examples added. Any other examples needed here?

2

Maybe something that shows how one can control the number of decimal places displayed?

Maybe how to better format a large number that is a result?

3

Wondering how to provide a decimal column as a parameter for Power ()
e.g. POWER([Fieldname], 0.425)

4

Emmanuel_C_Benjamin:

POWER([Fieldname], 0.425)

That should just work.

5

It throws an error saying something like “it expects two decimals as inputs. “ it does not accept field names unfortunately.

6

I suspect your column types are wrong, they need to be either Number or Decimal.

3X_f_c_fc0b8bd881ca43b2b2852de81f6b4788365feab3.png
3X_f_c_fc0b8bd881ca43b2b2852de81f6b4788365feab3.png525×116 2.26 KB

3X_8_f_8fe5956f22c3c45fce8858e22b15cfda2fab78f6.png
3X_8_f_8fe5956f22c3c45fce8858e22b15cfda2fab78f6.png335×237 4.89 KB

3X_0_6_06cfbdb1aad45205f4d43f2e253780d4fc40093b.png
3X_0_6_06cfbdb1aad45205f4d43f2e253780d4fc40093b.png972×376 15.3 KB

1 Like
7

Ah thanks a ton I was marking both as decimals. Much appreciated Marc. Greetings from Switzerland.