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

Excluding detail and suppressed records from calculations in crystal xi


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