Hi everyone,
I have the following use case, where I have a the columns: Project, Main Date, Start Date, End Date and Total Savings.
I need to sum the total savings from the Start Date to the End Date base on the Main date. I tried everything and I can manage to do it on Alteryx.
Below you can see and example (also attached file) of the data and the column result which already has the numbers I'm targeting.
Appreciate all your help.
As an example the result 6041.54 from row 5 is the sum of the total savings from 4/1/2023 to 7/1/2024 based on the main date.
| PROJECT | MAIN DATE | START DATE | END DATE | TOTAL SAVINGS | RESULT |
| Project 3 | 3/1/2023 | | 3/1/2024 | 0 | |
| Project 3 | 4/1/2023 | 4/1/2023 | 4/1/2024 | 377.5959583 | 4908.75 |
| Project 3 | 5/1/2023 | 4/1/2023 | 5/1/2024 | 377.5959583 | 5286.34 |
| Project 3 | 6/1/2023 | 4/1/2023 | 6/1/2024 | 377.5959583 | 5663.94 |
| Project 3 | 7/1/2023 | 4/1/2023 | 7/1/2024 | 377.5959583 | 6041.54 |
| Project 3 | 8/1/2023 | 4/1/2023 | 8/1/2024 | 377.5959583 | 6419.13 |
| Project 3 | 9/1/2023 | 4/1/2023 | 9/1/2024 | 377.5959583 | 6796.73 |
| Project 3 | 10/1/2023 | 4/1/2023 | 10/1/2024 | 377.5959583 | 7174.32 |
| Project 3 | 11/1/2023 | 4/1/2023 | 11/1/2024 | 377.5959583 | 7551.92 |
| Project 3 | 12/1/2023 | 4/1/2023 | 12/1/2024 | 377.5959583 | 7929.52 |
| Project 3 | 1/1/2024 | 4/1/2023 | 1/1/2025 | 377.5959583 | 8307.11 |
| Project 3 | 2/1/2024 | 4/1/2023 | 2/1/2025 | 377.5959583 | 8684.71 |
| Project 3 | 3/1/2024 | 4/1/2023 | 3/1/2025 | 377.5959583 | 9062.30 |
| Project 3 | 4/1/2024 | 4/1/2023 | 4/1/2025 | 377.5959583 | 9439.90 |
| Project 3 | 5/1/2024 | 4/1/2023 | 5/1/2025 | 377.5959583 | 9817.49 |
| Project 3 | 6/1/2024 | 4/1/2023 | 6/1/2025 | 377.5959583 | 10195.09 |
| Project 3 | 7/1/2024 | 4/1/2023 | 7/1/2025 | 377.5959583 | 10572.69 |
| Project 3 | 8/1/2024 | 4/1/2023 | 8/1/2025 | 377.5959583 | 10950.28 |
| Project 3 | 9/1/2024 | 4/1/2023 | 9/1/2025 | 377.5959583 | 11327.88 |
| Project 3 | 10/1/2024 | 4/1/2023 | 10/1/2025 | 377.5959583 | 11705.47 |
| Project 3 | 11/1/2024 | 4/1/2023 | 11/1/2025 | 377.5959583 | 12083.07 |
| Project 3 | 12/1/2024 | 4/1/2023 | 12/1/2025 | 377.5959583 | 12460.67 |
| Project 3 | 1/1/2025 | 4/1/2023 | 1/1/2026 | 377.5959583 | |
| Project 3 | 2/1/2025 | 4/1/2023 | 2/1/2026 | 377.5959583 | |
| Project 3 | 3/1/2025 | 4/1/2023 | 3/1/2026 | 377.5959583 | |
| Project 3 | 4/1/2025 | 4/1/2023 | 4/1/2026 | 377.5959583 | |
| Project 3 | 5/1/2025 | 4/1/2023 | 5/1/2026 | 377.5959583 | |
| Project 3 | 6/1/2025 | 4/1/2023 | 6/1/2026 | 377.5959583 | |
| Project 3 | 7/1/2025 | 4/1/2023 | 7/1/2026 | 377.5959583 | |
| Project 3 | 8/1/2025 | 4/1/2023 | 8/1/2026 | 377.5959583 | |
| Project 3 | 9/1/2025 | 4/1/2023 | 9/1/2026 | 377.5959583 | |
| Project 3 | 10/1/2025 | 4/1/2023 | 10/1/2026 | 377.5959583 | |
| Project 3 | 11/1/2025 | 4/1/2023 | 11/1/2026 | 377.5959583 | |
| Project 3 | 12/1/2025 | 4/1/2023 | 12/1/2026 | 377.5959583 | |
