Dynamic month: Sum Values
- 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 to everyone.
I´m working on a Workflow in order to get the total information of the last month.
For now, I was able to do it manually, but my goal is that the workflow can do it automatically without human intervention.
In the workflow you can see two browser, the first one is with the output that I need, the second one is when I tried to use a formula to get the last month from this database but the numbers don’t match and I can´t understand why (maybe the formula is wrong)
Thank you.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You did a calculation to figure out the previous month and year, but I done see where you ever filtered out the other months before doing your calculations so its inflating your numbers.
Add in the filter tool and I think you should be good.
datetimeformat([month],"%B") = [Previous_Month] and datetimeformat([month],"%Y") = [Previous_MonthYear]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @neromerob
All 1,487 records are being tagged as June 2022 so it's totalling them up; try the attached instead:
I've made the assumption you're ONLY wanting the month prior to the current month? Edited the formula and added in a filter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @neromerob
I added a formula to the filter tool w/o changing the way the dates are coming thru. See below container CA.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@neromerob one way of doing this dynamically. you need add the below custom condition in the filter tool
//Filtres all the dates based on the current month
DateTimePArse([month],'%Y-%m-%d') <= DateTimeFirstOfMonth()
AND
//taking the previous month records only
ToDate(DateTimeParse([month],'%Y-%m-%d')) = ToDate(DateTimeAdd(DateTimeAdd(DateTimeToday(),-1,'month'),-DateTimeDay(DateTimeToday())+1,'Day'))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator