Hi Guys n Gals,
This is probably an easy fix for the knowlegable amongst you, but for me....lol
I would like to get a rolling avearage of daily reporting figures. I have crated a report and added a weekly average cell but it is showing #DIV/0! until I enter a figure into the final days cell.
Could someone advise me how to get this rolling average cell to calculate on a daily basis?
Many thanks....
This is probably an easy fix for the knowlegable amongst you, but for me....lol
I would like to get a rolling avearage of daily reporting figures. I have crated a report and added a weekly average cell but it is showing #DIV/0! until I enter a figure into the final days cell.
Could someone advise me how to get this rolling average cell to calculate on a daily basis?
Many thanks....