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%
Person | Age | Months To 65th Yr | Gross Liability |
1 | 62 | 24 | (27,942.00) |
2 | 63 | 12 | (83,005.00) |
3 | 65 | 0 | (23,228.00) |
Solved! Go to Solution.
@KaraRademacher Adjust the formula if it is not correct also the field values
@KaraRademacher
I do have a minor modification on @binuacs solution.
This looks like it put me on the right track but I'm getting an error. I have attached some sample data with the basic workflow I'm using. It looks like the error starts with the gross calculation now that I substituted in [Prime Rate] instead of typing in a value. Ideally I will update this value early in the stream as a data source and let it flow through so I can update easily as needed. Anyways, can anyone assist with the parse error I'm seeing for the Gross Liability and Net Liability formulas? My belief is I need to change data types before these or something earlier in the stream.
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):
@FinnCharlton fixed a couple more formulas and it now works as expected. Thanks for the tip!