Aging calculation
- 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
Hello, I want to calculate aging in days as difference between a manual date inserted by me and dates coming from excel file attached.
The logic of date retrieved by excel is the following: for each row I need to consider starting from column BO (ACTION TYPE [PERFORMED BY]) the first field with Submitted word inside it (for example if BO is empty I need to go to BM, if BM is empty I need to go to BK etc..) until the first column ACTION TYPE [PERFORMED BY] filled with Submitted word and the that the date in the left column ACTION DATE.
So AGING = CUSTOM DATE - ACTION DATE
Thanks for support
Giovanni
- 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
- 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
Attached
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @elfunambolo
There was few modifications required. Here is the modified workflow.
Output:
Please and let me know.
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is missing this check -> I need to consider starting from column BO (ACTION TYPE [PERFORMED BY]) the first field with Submitted word inside it (for example if BO is empty I need to go to BM, if BM is empty I need to go to BK etc..) until the first column ACTION TYPE [PERFORMED BY] filled with 'Submitted' word
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is missing this part:
"The logic of date retrieved by excel is the following: for each row I need to consider starting from column BO (ACTION TYPE [PERFORMED BY]) the first field with Submitted word inside it (for example if BO is empty I need to go to BM, if BM is empty I need to go to BK etc..) until the first column ACTION TYPE [PERFORMED BY] filled with Submitted word and the that the date in the left column ACTION DATE."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @elfunambolo ,
feel free to check this one, I think this should do, what you are interested in, let me knof if this works.
I could not really make out what your "Custom Date" would be, so I just put at the end for the calculation the 1st of January 2020, but I am pretty sure you understand the concept in general.
If this works, please feel free to mark it as a solution as well as give a like.
Let me know in case you need any explanation in the workflow or if everything is understandable.
Best wishes
Olli
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Oliver,
I saw your design but the logic doesn't work. For example for Request# 207755409 the ACTION date should be 21/07/2020 with ACTION TYPE [PERFORMED BY] = Submitted (Kanisin, Devaraj[PO Adjustment (Other LE)]).
I see other two issue that before were absent: 1) some request# hasn't Action date filled and 3) some request# hasn't Aging calculation filled.
I attach my WF design and source data, I need only to add the logic that I wrote above.
