If/Then With Exponent

Question

In excel I have a net liability formula of =+IF(G5<65,+AZ5/(1+Summary!$C$7/12)^AU5,AZ5)

This is stating if the age of the person is less than 65 take Gross Liability/(1+rate/12)^# of mths to 65 otherwise use gross liability.

Gross liability is already calculated in Alteryx and is working as expected.

How do I create this same formula in Alteryx?

Here is a sample of data to use for this formula.  The rate to be used is 4.93%

PersonAgeMonths To 65th Yr Gross Liability 16224         (27,942.00)26312         (83,005.00)3650         (23,228.00)

binu_acs · Accepted Answer

@KaraRademacher Adjust the formula if it is not correct also the field values

Qiu · Accepted Answer

@KaraRademacher 
I do have a minor modification on @binu_acs solution.

FinnCharlton · Accepted Answer

Hey @KaraRademacher , your problem is indeed data types - go into every formula tool and every time you write a formula that results in a number, change the data type to a Double (see pic):

KaraRademacher · Accepted Answer

@FinnCharlton fixed a couple more formulas and it now works as expected.  Thanks for the tip!