Hello everyone,
This is a continuation of something I put up on the message board yesterday. I have a main report that has 3 subreports in it. Each report runs a calculation for Jan, Feb and March.
Now these subreports are supressed if the current date is less than the static date(1st of the month) coded in the formula. Ex: if the current date is Feb 19, then the March report is supressed.
I also have a Average formula on the main report that adds the 3 totals from the subreports and divides by 3.
However, if the 2nd report is supressed because it doesn't meet the condition in the formula then I want the average formula to divide by 1(Since there is only 1 report being displayed) and if the 1&2 reports are displayed and the 3rd one is supressed then I want the average formula to divide by 2 etc.
Any ideas how I can do this? Thank you
This is a continuation of something I put up on the message board yesterday. I have a main report that has 3 subreports in it. Each report runs a calculation for Jan, Feb and March.
Now these subreports are supressed if the current date is less than the static date(1st of the month) coded in the formula. Ex: if the current date is Feb 19, then the March report is supressed.
I also have a Average formula on the main report that adds the 3 totals from the subreports and divides by 3.
However, if the 2nd report is supressed because it doesn't meet the condition in the formula then I want the average formula to divide by 1(Since there is only 1 report being displayed) and if the 1&2 reports are displayed and the 3rd one is supressed then I want the average formula to divide by 2 etc.
Any ideas how I can do this? Thank you