Hi Nigora! I recommend moving the date filter onto the filters shelf so it's an actual filter. You can do this by adding the date/time field onto the filters (as MDY), going to the Condition tab, and adding in a formula, perhaps like this:
Then you can try doing a plain running sum without the IF statement.
Hmm, that's strange, I thought that would have worked. Can you post a packaged workbook so I can tinker with it?
1 of 1 people found this helpful
Agree with David, a standard filter and standard running sum would be better. A parameter may not be necessary at all but if you feel a standard date/time filter can't be used then you'll need to write a calculated field to act as your filter.
For example the calculated field could be as simple as [Date Range] = [Date] and set it to be 'True' on the filters shelf.
To be clear your running sum would only be RUNNING_SUM(SUM([Metric]))