Problem with Formula

[rpal]

I have formula called @EndingBalance.
@EndingBalance={@Begin Balance}+Sum ({GLTRANS.BASE_AMOUNT}, {GLTRANS.ACCOUNT})
If I am placing @EndingBalance formula in AccountGroup Footer section I am getting bignumber than I should. But
if I place same @EndingBalance formula in the AccountGroup Header section I am getting correct number. I did not understand what make diffrence in the Header and Footer.

-Rpal

 

[synapsevampire]

Depends on what's in @Begin Balance, please share that.

-k

 

[rpal]

Hello synapsevampire,
Following is the {@Begin Balance} formula:

if datepart("m",{GLTRANS.POSTING_DATE})=1 then
{GLTRANS.BASE_AMOUNT}
ELSE
if datepart("m",{GLTRANS.POSTING_DATE})=2 then
({GLAMOUNTS.DB_BEG_BAL}+{GLAMOUNTS.DB_AMOUNT_01})+
({GLAMOUNTS.CR_BEG_BAL}+{GLAMOUNTS.CR_AMOUNT_01})
else
if datepart("m",{GLTRANS.POSTING_DATE})=3 then
({GLAMOUNTS.DB_BEG_BAL}+{GLAMOUNTS.DB_AMOUNT_01}+{GLAMOUNTS.DB_AMOUNT_02})
+
({GLAMOUNTS.CR_BEG_BAL}+{GLAMOUNTS.CR_AMOUNT_01}+{GLAMOUNTS.CR_AMOUNT_02})

 

[Ngolem]

well...the Sum will calculate the same no matter where it is because it is done before the records are printed

The other part - {@Begin Balance} - uses different data when in the Header than in the Footer.

In the header it uses the first record for the AccountGroup and in the footer it uses the last record.

It seems you want the first record data for some reason.

Jim Broadbent