How can we use a caret ^ symbol in Alteryx

Sameer_Kanade8810

Hi All,

I have two values like below column
Value 1 Value 2 Value 3
0.031717757 90 ?

I need a formulae like below , using a caret ^ symbol

=(1+,[Value1])^(1/[Value2])-1

I this possible in Alteryx.

Tips and Tricks

Data Investigation

Accepted answers

Hi @Sameer_Kanade8810

You can implement this by using the pow function.

Use the caret symbol.yxmd

All comments

Hi @Sameer_Kanade8810

You can implement this by using the pow function.

Use the caret symbol.yxmd

@Sameer_Kanade8810

pow(number,p)

Sameer_Kanade8810

Thank you @Emmanuel_G & @geraldo

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15881

MarqueeCrew 13708

apathetichell 13703