Skip to Content
0
Former Member
Mar 02, 2011 at 05:03 PM

Excluding detail and suppressed records from calculations in crystal xi

396 Views

Is there anyway to exclude records from calculations in crystal xi

The report design contain group level A, group level B and group level C

In Group level C - the sorting order ensures that the most recent (and in this scenario relevant record) is displayed first - this is the record which is required for the calculations. This record is then moved into Group Level C header - thus only displaying the first record in this group. However any calculations which take place take into account all the detail records in Group Level C, and as a result the calculations are incorrect.

Running Totals are not an option as also on this report - in certain scenarios Group Level C may be suppressed altogether - is there anyway to exclude suppressed records from the calculations?

It is necessary to carry out the following calculations, using only the (unsuppressed) value from Group Header Leve C: Sum, Mean, Median

Thank you in advance