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
Solved! Go to 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 😀👍
Thats it! Thanks so much for the quick response!