ashleyuk1984
11-23-2017, 04:32 AM
Hi,
My title might not be very clear, but I'll try to explain as best as I can, what I require help with.
I run a weekly report and on this report are a number of chargeable items, but the number of chargeable items only start if the value is over 3..
So, if the items only go up to 2 on that paticaluar line, then the number of chargeable items is 0.
1 = 0
2 = 0
3 = 0
4 = 1 (because we're now into charging territory) (it's basically 4 - 3 = 1)
5 = 2 (because we're now into charging territory) (it's basically 5 - 3 = 2)
6 = 3 (because we're now into charging territory) (it's basically 6 - 3 = 3)
It gets tricky, because these rows are grouped together by a "Master Reference"... But I need to calculate each row separately to get the true figure.
21031
I've attached an example spreadsheet to show my problem.
I hope you can help.
Thanks
My title might not be very clear, but I'll try to explain as best as I can, what I require help with.
I run a weekly report and on this report are a number of chargeable items, but the number of chargeable items only start if the value is over 3..
So, if the items only go up to 2 on that paticaluar line, then the number of chargeable items is 0.
1 = 0
2 = 0
3 = 0
4 = 1 (because we're now into charging territory) (it's basically 4 - 3 = 1)
5 = 2 (because we're now into charging territory) (it's basically 5 - 3 = 2)
6 = 3 (because we're now into charging territory) (it's basically 6 - 3 = 3)
It gets tricky, because these rows are grouped together by a "Master Reference"... But I need to calculate each row separately to get the true figure.
21031
I've attached an example spreadsheet to show my problem.
I hope you can help.
Thanks