Problem using POW

[wonka1234]

Hi,

I am trying to calculate this excel formula in alteryx

expecting .0004

my formula: POW((1+[Coupon]/200),(2/12)-1)*(12/365)

coupon = 1.5595

What is wrong with my formula?! cant seem to get it.

[IraWatt · Accepted solution]

Hey @wonka1234,

You have misplaced the minus 1 in the Alteryx formula it should be: 

(POW((1+1.5595/200),(2/12))-1)*12/365

 Your Alteryx formula is including the 1 in the power exponent.

Any questions or issues please ask :)
HTH!
Ira