Skip to Content

Show Formula Results in CR Detail Reports

I have a field "Status". This field has three different entry options; Juror, Returned, and Alternates.

I need to sum/count the total number for each CaseID (Grouping by):

Data will be display in detail section of CR report as follows:

Question:

How do I get the results to display in detail section of CR, with a sum total?

I have the following formula field:

// Formula name: Juror Count/Sum

IF {PANEL_SUMMARY_REPORT_VIEW.STATUS} = "Juror" THEN 1 ELSE 0

But, it displays like so:

cr-matrix.jpg (167.9 kB)
results.jpg (63.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 13 at 01:47 PM

    Hi Juan,

    1. Insert a Group on the Case# field

    2. Move all fields (except the formula field you created to display Juror count) from the Details Section to the Group Footer

    3. Go to the Insert Summary Option > Select the Formula field to sum on > Under Summary Location select Group Footer

    4. Create similar formulas and summary fields for the remaining fields as well.

    5. Suppress the Details Section.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 14 at 09:00 PM

    Abhilash, thank you. I have left a comment for you.

    Add comment
    10|10000 characters needed characters exceeded