Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the best way to calculate difference is account balance.
Overview of what I have done so far:
I think you need to wrap your before-expression within an aggr-function - see here Calculating rolling n-period totals, averages or other aggregations to the example of the rolling 3-months which is quite similar to your task.
- Marcus