I am working on a calculation in which I need to find the total amount of a value for each month in ProcessBook. However, when choosing the time interval, it only allows for 30 days, which as you know is not always the same as the given month. Is there a way to choose the time start and end like in Excel?
There is currently a month-to-date tag for this, which I will use the maximum value from as my input. The main issue is the layover from each month which could then use the maximum value from the previous month rather than the maximum of the current month (ie August 31 instead of September 30).
Feedback on this issue would be greatly appreciated, and I thank you in advance.