Issue with Payment formula

[Nilsend]

I am looking to have Alteryx insert payments in periods based on payment frequency but I am stuck .

[binuacs]

@Nilsend Can you provide some sample data and expected results for a better understanding?

[Nilsend]

@binuacs See attached. I would like for the generated rows to be the same but for Year payments to only show on yearly payment lines 

[AndrewDMerrill]

You can change your Generate Rows Tool "Loop Expression" to: DateTimeAdd([Date], 1, [Payment Frequency])

Would that accomplish what you are looking for?

[Nilsend]

Yes, I did that way originally but I would like to show the balances for each month in between without the payment being in each period