Skipping previous month load if it is January
- 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 Masters
I have a workflow where I need to calculate the current month value which is obtained by subtracting the previous month YTD from the current month YTD.
By selecting the current date in the interface, the dynamic input pulls automatically the previous month file and makes a join with the current month file.
This works fine for every month but the first month of the year for which there is no previous month data.
Is there a way to add a condition to skip/ignore the dynamic input from previous month (highlighted below) if the selected month is January?
Thanks
Felipe
Solved! Go to Solution.
- Labels:
- Date Time
- Developer Tools
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try adding a filter after the input file with DateTimeMonth([Current Month]) != 1. Send the true side on through the process. You may need to do something with the false side to pass through a message to the user that there isn't a prior month in the YTD data.
- 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 Geraldo!. I had to make a small addition to your solution but it showed me how to solve it!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Agreed, this is the easiest way to do so.
