How to get the value of the total summary of crosstab in crystal report?

[lotus18]

Hello World!

I got stuck with my program and I can't figure it out by myself. I have a problem in getting the total summary of my crosstab. Here's my sample report.

As you can see on my report, you will notice that I set the Section Footer (it is not visible here) to Suppress (No Drill Down). Here's my formula

if {creditmemo_list.CreditReturn}="Yes" then
    true
else
    false

And it works fine. All I want is to get the value of total summary (Sum of @ii) of the crostab and subtract it to the value of #TotalBalance and the result would be the @GrandTotal. The formula of my @GrandTotal should be

{#TotalBalance} - {(Sum of @ii)} <-Actual value of this object
 

Is this possible? If not, is there any alternative solution to my problem? Please help. This is urgent.

Rey Sean

[lotus18]

Hello I'm calling all experts of this community. Please post some reply here... I just want to know if there is another way to solve my problem. Thanks!

Still waiting for your replies :'(