Forum Discussion
calculation between two report
Hi, I have a volume report used for months. Now we face a problem that we need to re-calculate the number of last year Dec and this year Jan. We prepared another report with volume amount a...
Anonymous
I don't fully understand your problem yet.
Where does your second report come from? How is the data source different or similar to the first report? What do the data source look like in their raw format?
What do you want to do with the 200 amount from Feb 2020 in the second report in your sample you have posted?
Do you always add to December of previous year, or just to previous month?
So for the example above, would we need to take the 200 from Feb 2020 and move that to Jan 2020? to Dec 2020? Or leave in Feb 2020?
Let us know some more info and we can offer up ideas.
I don't fully understand your problem yet.
Where does your second report come from? How is the data source different or similar to the first report? What do the data source look like in their raw format?
What do you want to do with the 200 amount from Feb 2020 in the second report in your sample you have posted?
Do you always add to December of previous year, or just to previous month?
So for the example above, would we need to take the 200 from Feb 2020 and move that to Jan 2020? to Dec 2020? Or leave in Feb 2020?
Let us know some more info and we can offer up ideas.
The first report is the full report of volume including all years amounts. The second report which is only including the amount of Jan every year , is for adjustment to move the amounts from Jan to last year Dec. The second report data format is as below.
Amount Date 100 Jan/1/2020 200 Jan/2/2020 200 Jan/1/2019 ... For example , we have 300 in Jan 2020 and 200 in Jan 2019 . I want to move 300 to Dec 2019 and 200 to Dec 2018 of first report.
Thank you for your kindly help 🙂