Iterating through formulas using Macro

[wonka1234]

Hi,

I am trying to iterate through my data to I can come up with an amortization schedule.. I need to loop through as formulas must be recalcuated. I cant seem to get it working, can anyone help on this?

Expected Output

OPEN BAL	PAYMENT	# of INT Days	INTEREST	PRINCIPAL	PRE-PAY	LIQUIDATION	TOTAL CF	CLOSE BAL
49,226,066	(663,932)	31	(64,989)	(598,942)	(68,196)	(353,309)	(1,085,437)	48,205,619
48,205,619	(658,193)	30	(61,589)	(596,604)	(66,768)	(345,912)	(1,070,874)	47,196,334
47,196,334	(652,476)	31	(62,310)	(590,167)	(65,362)	(338,625)	(1,056,464)	46,202,180
46,202,180	(646,837)	31	(60,997)	(585,840)	(63,974)	(331,434)	(1,042,244)	45,220,933
45,220,933	(641,246)	29	(55,850)	(585,396)	(62,598)	(324,307)	(1,028,152)	44,248,631
44,248,631	(635,649)	31	(58,418)	(577,231)	(61,246)	(317,302)	(1,014,197)	43,292,852
43,292,852	(630,155)	30	(55,313)	(574,842)	(59,909)	(310,375)	(1,000,439)	42,347,725
42,347,725	(624,681)	31	(55,908)	(568,773)	(58,592)	(303,552)	(986,826)	41,416,808
41,416,808	(619,282)	30	(52,916)	(566,367)	(57,290)	(296,806)	(973,378)	40,496,345
40,496,345	(613,903)	31	(53,464)	(560,439)	(56,007)	(290,161)	(960,072)	39,589,737

[Luke_C]

Hi @wonka1234 

Take a look at the below post. At first glance, your macro isn't configure properly. It is still set as a standard macro in the workflow configuration. Iterative macros also require two macro output tools - 1 for the data to be output and one for the data that should be looped back through.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-use-Alteryx-to-prepare-a-amorti...

[Ben_H · Accepted solution]

Hi @wonka1234,

Is this the kind of thing you're after?

I borrowed the workflow you posted before as I thought it didn't need multi row formulas for everything.

The results might not be exactly right based on the formulas (and the fact that they're all INTs and therefore may have rounding issues) but it shows you how you could iterate this.

Regards,

Ben