Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Issue with Payment formula

Nilsend
6 - Meteoroid

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

4 REPLIES 4
binuacs
21 - Polaris

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

Nilsend
6 - Meteoroid

@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 

CoG
14 - Magnetar

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

Would that accomplish what you are looking for?

Generate Rows 1.png

Nilsend
6 - Meteoroid

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 

Labels