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.

[Emmanuel_G · Accepted solution]

Hi @Sameer_Kanade8810 

You can implement this by using the pow function.

[geraldo]

@Sameer_Kanade8810 

pow(number,p)

[Sameer_Kanade8810]

Thank you @Emmanuel_G & @geraldo