I have a column of figures based on (Total Production Figure for the year minus Current Production Figure) divided by (52 weeks minus Current week number) which gives me a list of figures with a number of decimal places.
My problem is, if I use the "ROUND" fuction to rduce them to integers, the column the totals more than the total production figure for the year.
Is there a way around this?
Hope this makes sense, thanks in advance.
My problem is, if I use the "ROUND" fuction to rduce them to integers, the column the totals more than the total production figure for the year.
Is there a way around this?
Hope this makes sense, thanks in advance.