balance column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone,

I am having a strange problem trying to make a balances column in my report:

I have an open balance field at the top of my report which is a calculated
field from previous balance history. I would like to add a sum of
commissions payed for each invoice and put it in a balance column. what I
would like is this:

Open balance : -$7800
<-header
sum of commissions $ 0 balance $7800.00 <-detail footer
sum of commissions $ 1210.0 balance : -$6590.00 <-detail footer
sum of commissions $ -2750.00 balance : - $9340.00 <-detail footer

my equation for balance field is :[openbalance] + [sumOfCommissions]
no sum running enabled

what I am getting is this:

Open balance : -$7800 <-header
sum of commissions $ 0 balance $7800.00 <-detail footer
sum of commissions $ 1210.0 balance : -$6590.00 <-detail footer
sum of commissions $ -2750.00 balance : - 10555.00<-detail footer

So the 3rd balance is summing (-1210 - 2750), but I only want $-6590 - $2750

I don't know what I am doing wrong

any assistance would be great.

David
 
dp said:
I am having a strange problem trying to make a balances column in my report:

I have an open balance field at the top of my report which is a calculated
field from previous balance history. I would like to add a sum of
commissions payed for each invoice and put it in a balance column. what I
would like is this:

Open balance : -$7800
<-header
sum of commissions $ 0 balance $7800.00 <-detail footer
sum of commissions $ 1210.0 balance : -$6590.00 <-detail footer
sum of commissions $ -2750.00 balance : - $9340.00 <-detail footer

my equation for balance field is :[openbalance] + [sumOfCommissions]
no sum running enabled

what I am getting is this:

Open balance : -$7800 <-header
sum of commissions $ 0 balance $7800.00 <-detail footer
sum of commissions $ 1210.0 balance : -$6590.00 <-detail footer
sum of commissions $ -2750.00 balance : - 10555.00<-detail footer

So the 3rd balance is summing (-1210 - 2750), but I only want $-6590 - $2750
Click to expand...


You need to use an invisble running sum text box bound to
the sum of commissions field. Then the balance column's
text box would use the expression:
=OpenBalance + runningsumtextbox
 
Thanks SO much, that was vexing me. That was exactly it. Funny, i had to
change the format type to general number from currency or else it gave me an
error.

cheers again,
David

Marshall Barton said:
dp said:
I am having a strange problem trying to make a balances column in my report:

I have an open balance field at the top of my report which is a calculated
field from previous balance history. I would like to add a sum of
commissions payed for each invoice and put it in a balance column. what I
would like is this:

Open balance : -$7800
<-header
sum of commissions $ 0 balance $7800.00 <-detail footer
sum of commissions $ 1210.0 balance : -$6590.00 <-detail footer
sum of commissions $ -2750.00 balance : - $9340.00 <-detail footer

my equation for balance field is :[openbalance] + [sumOfCommissions]
no sum running enabled

what I am getting is this:

Open balance : -$7800 <-header
sum of commissions $ 0 balance $7800.00 <-detail footer
sum of commissions $ 1210.0 balance : -$6590.00 <-detail footer
sum of commissions $ -2750.00 balance : - 10555.00<-detail footer

So the 3rd balance is summing (-1210 - 2750), but I only want $-6590 - $2750
Click to expand...


You need to use an invisble running sum text box bound to
the sum of commissions field. Then the balance column's
text box would use the expression:
=OpenBalance + runningsumtextbox
Click to expand...
 
Back
Top