Running Totals and Grouping

[GC2000]

I have created a mock crosstab (CR2008) so that I would be able to display a value for every metric even if it was zero (current crosstab limitation). I have this displayed in the report footer and the values are calculated properly. My issue is though that I want the final totals to appear first and then show individual group results. So the first mock crosstab would be a grand total of the 10 crosstabs beneath it. I think this can only be done as a subreport but if anyone has any other idea's please let me know.

 

[lbass]

Not sure what your conditions are, but you could probably use conditional formulas instead of running totals for your manual crosstab. Then you could insert summaries on the formulas and drag the results into the report header. You can then use the groups in the main body of the report for your more detailed results.

-LB

 

[GC2000]

Thanks LB and sorry for the delay but I had another project to complete. I am not sure why I did not try this before but I am going through the process now. It looks like it should work. However the one issue I am having is for one of the MTTF formulas that I am using the Business Days calculation for is returning 2 different results. When I do the average of the Business Days as a Running Total Average I get one value and then when I do it as a formula and do an Average Summary on it I get a different result? Any idea why the difference or which one is actually correct?

 

[GC2000]

New update. The running total and the formula are both correct if they both appear in the footer. The issue is that the formula changes when I move it to the report header and it is no longer correct. Anyone know anyway to correct this?

 

[lbass]

If you are using a manual running total to get the average, yes, it will be incorrect in the report header. If you are using a complex business days formula, maybe you should go the subreport route.

-LB

 

[GC2000]

I know the Running Total is incorrect in the report header so that's why I went with a summary. I recreated the running total as a formula and then did a summary on it. But when I pull that summary to the report header it is different than the summary in the group. At this point I may have no choice but to use a subreport. This behaviour is very odd though.

 

[lbass]

I would have to see the summary formula, along with the original business days formula, to troubleshoot it.

-LB