Summation of non-suppressed details

I’m using Crystal 8.5. The report is displaying a field with details which are numeric values. The records will be listed with the corresponding value in a tabular form.

What I did was to suppress some of the details based on a condition set on the ‘Format Section’ of the details.

I then inserted a grand total option on the same field with the numeric values. The problem is that the grand total seems to include the suppressed values, so I’m seeing inflated totals.

How do I set the grand total to show only the non-suppressed (i.e. the visible) records? Do I need to use some other feature instead of the grand total? I’ll appreciate any insights. Thanks.

Which NAV version is this about?