Hello! I've 2 data sources one with Project information and other with Financials information. Attached file is a dummy example of these 2 data sources.
Project: Has a bunch of columns but I've listed only the 2 prominent columns. Terminals and Close_date.
Every terminal has multiple close dates associated with every project.
Financial: Has a bunch of columns but I've listed only the 4 prominent columns. Terminals, Month, Year, $. I've listed data only for terminal 12 and 2019 as an example. But Financial information exists for every terminal, month, year combination starting from year 2019 and beyond.
I've joined both the sources to give one output with Terminals, Close_date, Month, Year, $. What I want to do here is for every terminal and close date combination, I want to look on the financial info and "sum $ 6 months before close_date" and "sum $ 6 months after close-date". For example on the Project tab, line 1 has terminal 12 and close date of 11/2/2020. So I want to look at financial info for terminal 12 and sum 6 months before 11/2/2020 and sum 6 months after 11/2/2020. This process needs to be repeated for every Terminal - close date combination.
Output needs to be Terminals, Close_date, Sum ($ 6 months before), Sum ($ 6 months after).
Solved! Go to Solution.
@mercurial_maverick
To check if it works dynamicly for multiple entries, I added some dummy data for testing.
@Qiu Hello Qi! Not compatible with my version (2019.4.8.22007). Could you please resend to align my version?
@mercurial_maverick
How can I do that to make it compatible??
Upgrade your version, since it is already very old. hehe😁
@Qiu Ha ha that would be an org level change. anyways can you not send it as a packaged workflow? Same way as brandon did
The version compatible issue is a problem, but in my case, I can just force open it for most of the cases.
And actually you can unzip the package using any Zip software, but anyway, here you go.
Glad to know your problem gets solved.