Exponent Formula Issue

[wonka1234]

Hi,

I am trying to do an exponent formula

POW((1+[Coupon]/200),(2/12)- 1) , which is getting 0.99355

But in excel I am getting  =((1+V14/200)^(2/12)-1).

0.001295

Coupon or V14 = 1.5595.

Where am I going wrong?

[IraWatt · Accepted solution]

Hey @wonka1234,

In your excel formula the -1 is not part of the power exponent. eg. you have done (1+V14/200)^(2/12) then minus 1.

Whereas you have included -1 as part of the power Exponent eg. in the Alteryx formula is (1+V14/200)^(2/12-1).

I think you want your Alteryx formula to be POW((1+[Coupon]/200),(2/12))-1

[Jotigautam]

This is due to BODMAS math rule 

Exponentiation is performed before division and you are not putting brackets to allow 2/12-1 to happend beforehand. Putting brackets around (2/12-1) will help

That is the reason for different anwers.

instead of ((1+V14/200)^(2/12)-1) if you put ((1+V14/200)^((2/12)-1)) in excel you will get same answer