Stock Aging Report -Adding debit values to another credit field
I am hoping someone can help with this,it is really urgent. I have attached a print screen of the data as it is showing currently on a table.
We have a negative value in the current month
Month 1: 579
We do not reflect the negative values on a field, so it is hard coded out, the problem is that I need to subtract that value from the previous month with a positive value, in this case it is one month only but it it may be that there are 6 months between the months, there may even be two months with negative values that need to be offset against a positive field.
It might help if you prepare a "running total" column which reflects the true negative value (which in you example are the real values behind "Current" & "Month 2"). This will allow you to display "0" for both these months, but also keep track of when you rise above "0" again.