Help with Generate Tool Setup

[JMart2135]

Hello Everyone,

I have a dataset that contains the following data:

Primary Key	Limit	CurrentHours	MonthlyUse	CurrentMonth
1	1200	750	15	Oct 2020
2	1000	500	15	Oct 2020

I have the table automated so that [current hours] will get update on a monthly basis. I need to be able create a new column based on the following:

create column [RunningTotal]=[CurrentHours]+[MonthlyUse] and calculate the running total until the running total >=[Limit] and for each row created, take the [CurrentMonth] and add 1 month for each new [RunningTotal] created. 

In the end, I am just trying to be able to project the estimated date that I will surpass the limit based on the running total. I tried using the generate tool, I am just having some issues getting it set up correctly.

Thanks ahead of time for any help!

-Jesse

[atcodedog05 · Accepted solution]

Hi @JMart2135 

Here is a workflow for the task. As per my understanding.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[JMart2135]

Thats it! Thanks so much for the quick response!

[atcodedog05]

Happy to help 🙂 @JMart2135 

Cheers and Happy Analyzing 😀