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

[Steven_Coile]

POWER()

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

[Colin1]

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?

[Emmanuel_C_Benj]

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

[Marc_Dillon]

Emmanuel_C_Benjamin:

POWER([Fieldname], 0.425)

That should just work.

[Emmanuel_C_Benj]

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

[Marc_Dillon]

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

[Emmanuel_C_Benj]

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