jeran042
Registered User.
- Local time
- Today, 04:42
- Joined
- Jun 26, 2017
- Messages
- 127
DSum Through Previous Month
Good afternoon all,
I have a query that has a spread of number broken down by month.
Picture $12,000, broken down by month, so $1k each month.
The current structure of the query is a department name, and each of the months.
In addition, there is a calculated field. A DSum where I add up all of the month -1. So in this instance, January - May, so $5k.
The problem is that this is manual, and I want to try a formula based approach.
Can someone point me in the right direction on how to write this formula?
Here is what I have so far:
Good afternoon all,
I have a query that has a spread of number broken down by month.
Picture $12,000, broken down by month, so $1k each month.
The current structure of the query is a department name, and each of the months.
In addition, there is a calculated field. A DSum where I add up all of the month -1. So in this instance, January - May, so $5k.
The problem is that this is manual, and I want to try a formula based approach.
Can someone point me in the right direction on how to write this formula?
Here is what I have so far:
Code:
SUM: Nz([JANUARY],0)+Nz([FEBRUARY],0)+Nz([MARCH],0)+Nz([APRIL],0)+Nz([MAY],0)
Last edited: