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:





