Dates column

[Tim6]

Hi There, 

I hope all is well.

I need to make a workflow to calculate a daily balance from Jan 1 - Dec 31.

However, the data I have only has the balance from December 31 2019 

Goal: Calculate the daily balance

Question: For every unique identifier, is there a way I can build a date function in Alteryx that will create dates for each month (Jan 1st – Jan 31st etc)?

Or would I have to use the formula tool to create individual dates in Alteryx for each month.

Please let me know what you think.

Thank you, 

[Jonathan-Sherman · Accepted solution]

Hi @Tim6,

You're certainly on the right lines!

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Tim6]

@Jonathan-Sherman Thank you for the showing how to use the multi-row tool that helped for the payment column ! 

Still having slight issues with the outstanding balance as the formula tool wont work for that because the outstanding balance needs to take into consideration the previous day balance that was lowered by the payment.

EX.

Day 1

Outstanding balance = 5000

Payment = 0

ending balance = 5000

Day 2

Outstanding balance = 5000

Payment = 1000

ending balance = 4000

Day 3

Outstanding balance = 4000

Payment = 0

ending balance = 4000

would you be able to help me with this?

[Jonathan-Sherman]

Hi @Tim6,

That is why I use the multi-row formula to create the "running total" of the payment column. Which can then be subtracted from the Initial Loan amount.

Before multi-row formula:

After multi-row formula:

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan