Skip to Content
0
Jun 24, 2018 at 06:09 PM

Sum Totals in Report Header

668 Views

Team:

I currently have a Formula (A-Green) in the Report Header and it displays just like the one in Report Footer (A-Red). I have another Formula (B-Green) that will not display correct sum amount. The formula (B-Red) in the footer does display and is using this formula:

(Sum of @Amount Requested from State) with the following condition for (B) - Trim({table.field}) ="Grand Jury"

I'm missing the correct Crystal Syntax for (B). I have included screen shot to show visuals of design view and Preview:

Attachments

totals-one.jpg (210.4 kB)
a2-screen.jpg (82.1 kB)
b-screen1.jpg (44.7 kB)
b2-sceen.jpg (19.4 kB)
ab-results.jpg (21.4 kB)
ab-rf.jpg (21.0 kB)