YTD - Calculate YTD Amount based on month name

Hi All,

I have data by month as shown in the below screenshot. I need alteryx to calculate YTD based on the months completed in an year. Also the last completed month should be current month. for example if we are in Dec, current month will be Nov and YTD will be Jan-Nov.

Kindly need your help.

Thanks,

David

Reporting

Accepted answers

MatthewO

@david_shishir attached is an example workflow. This approach converts the the column headings to a date field so that the Current Month and YTD can be properly derived at the time the workflow is run. I hope this is helpful for you!

YTD.yxmd

All comments

ShankerV

Hi @david_shishir

Yes, it is possible.

You can get the current month with help of datetimenow() and then perform the calculation for the previous months.

Let me know if you need to build a solution for the same.

Many thanks

Shanker V

david_shishir

yes please, that would be of great help.

ShankerV

Hi @david_shishir

Sure, happy to help!!!

Few minutes please.

MatthewO

YTD.yxmd

ShankerV

Hi @david_shishir

Please find the below expected output.

Year to Date (YTD) = [(Current Period Value – Beginning of Period Value)] ÷ Beginning of Period Value)

I have used this formula to create the YTD

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

YTD - Calculate YTD Amount based on month name.yxmd

david_shishir

Hi Matthew, Thank you for the solution. Just one issue we need to address is that if we are in Jan of the new year, then the current month should be Dec of the last year and YTD needs to be whole past year. Can you please tweak the workflow to accommodate it so that it would be a fool proof solution.

MatthewO

@david_shishir updating the logic in the Formula tool will accomplish this for you. The attached version has this change. Admittedly, I don't really encourage this type of logic as it's an assumption. My recommendation would be to consider using actual dates in your data set, you can always format them to your liking later in the workflow output.

YTD_v2.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703