hello all,

i have this 3 fields, and from this 3 fields i want to calculate a running cumulative balance.

this are the ff. fields

1. Opening Balance
2. Debit
3. Credit

the formula is Opening balance + debit - Credit. this is my actual CR formula

({OpeningBalance.Open Balance} + {BP_AccountBalance;1.Credit}) - {BP_AccountBalance;1.Debit}

but using the above formula does not get the desired result.

please help.

thanks.

Fidel

hello lockwelle,

thanks a lot to your response. you formula works fine. but i have problem with duplicated rows in the debit side. i just used the suppress if duplicated in the format editor. how will i say to crystal report that only the first record from the duplicated rows will be minus in {dBalance} + (Credit).

please see my screen shot

http://i264.photobucket.com/albums/ii184/abing430/CRDuplicatedRows.png

http://i264.photobucket.com/albums/ii184/abing430/CRDuplicatedRows-1.png
please help

best regards,

Fidel

Edited by abing430 - 18 Jan 2011 at 6:35pm

do you have a reset formula in the group header or the pager header.  How does it get the opening balance, does getting the balance override / reset the variable.

hello lockwelle,

I try to apply your formula into my CR report,

I face this problems:
"A running total cannot refer to a print time formula detail @BFAmount"

I set the formula as per your guide but I do add the running total tool too.

Should I take out the running total too?

Thanks for you help

After take out the running tool, my report is running correctly.

But another question raise now.
I have a b/f value, but not transaction for that accounts/product. Then the whole detail is not shown up.

How to solve this problems? Any suggestion on this.

Other all work perfectly.