Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How can we use a caret ^ symbol in Alteryx

Sameer_Kanade8810
7 - Meteor

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.

3 REPLIES 3
Emmanuel_G
13 - Pulsar

Hi @Sameer_Kanade8810 

 

You can implement this by using the pow function.

 

Emmanuel_G_0-1686786952642.png

 

geraldo
13 - Pulsar

@Sameer_Kanade8810 

 

pow(number,p)

Sameer_Kanade8810
7 - Meteor

Thank you @Emmanuel_G & @geraldo 

Labels