Adding Column Values as per present month
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @atcodedog05 ,
I have two excel files
1)File1: 2021m07
2)File2: Final_report_07_2021
File1 is empty and File2 has a data.
Requirement:
File2 has columns with the month names.
I have to Sum these columns amount in a way that it adds up from Jan to present month.
For Example: These files are for month July , so it should add (Jan to Jul)/1000
For the next month it should add from (Jan to August)/1000
Desired_Output:
Result
381
My approach : i thought to take the month name from File name and map it with the column month name.
Can you help to solve this in better way or with my approach?
Regards
Areeba
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @areeba
It would be something like this. But your values don't seem to match please check on that.
Workflow:
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @areeba
Cheers and have a nice day!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @atcodedog05 ,
I have a similar situation, only difference is my File name is '2021m07 IT Save Forecast' instead of 'Final_report_07_2021'. can you help me with the Regex to write in formula to extract month?
Regards
Areeba
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @atcodedog05 .
Thank you for the reply , after applying your regex i am getting this:
i think it should print 1400-07-01 instead of 2021-07-01, like you did in previous workflow.
Regards
Areeba
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @areeba
Try this formula
DateTimeParse(Right([FileName],20),"m%m IT Save Forecast")
Snapshot:
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks