calculate Month over the Limit

[LEXQ2005]

I want to calculate which month the value will over the limit.

The data source is:

The desired result “Month Over Limit” will be:

In Excel, I can do calculation like below to get the result:

How can I get the Month Over Limit in Alteryx?

[RolandSchubert · Accepted solution]

Hi @LEXQ2005 ,

you can use the Formula tool to solve your problem - it's a bit of DateTime calculation. I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland

[LEXQ2005]

@RolandSchubert 

Thanks, Roland.

Sorry, I cannot not open your attached file. The Alteryx version I’m using is Alteryx Designer 2019.3

[jarrod]

Hey @LEXQ2005 , 

if you right click the workflow and open in a text editor, you can change the version number in the xml to something prior, like 2019.1 and save and try opening again. Alteryx will do the rest. 

edit: see screenshot below

[LEXQ2005]

I opened the MonthoverLimit.yxzp file using NotePad++.
This is what I get:

[jarrod]

Oh, I didn't realize it was yxzp. in that case, I believe you can change the extension to .zip and unzip to the folder. Then you should be able to open the yxmd.