Calculate Total

[jk]

In my report i have a sum of withdrawal box and a some of deposit box which
work fine. I am trying to create another box next to these boxes called final
balance with a formula of :
=Sum([DepositAmount]-[WithdrawalAmount])

I have used a text box and the above formula in the expression builder but
the text box i inserted does not even appear when i do a review.

 

[Al Camp]

I can't say why it doesn't even show. It should , but will probably be the wrong
calculation.
It should be...
= Sum(DepositAmount) - Sum(WithdrawalAmount)

If you could indicate a few sample lines from the report, (what you have vs what you
want to see)...that would help.

 

[jk]

That worked Great!!!! Now i have to ask since the report has a grouping per
account name, there is a sum for the deposit column and a sum for the
withdrawal column for each each group name. How do i add balance to each
group so it shows a running balance per group name?
ACCT NAME DEPOSITS WITHDRAWALS BALANCE
RUSSIA 1000.00 500.00
1000.00 100.00
SUM 2000.00 600.00 1400.00

INDIA 600.00 100.00
SUM 600.00 500.00

Does the above help describe what i guess is a per group running balance ?
Thanks

I can't say why it doesn't even show. It should , but will probably be the wrong
calculation.
It should be...
= Sum(DepositAmount) - Sum(WithdrawalAmount)

If you could indicate a few sample lines from the report, (what you have vs what you
want to see)...that would help.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

In my report i have a sum of withdrawal box and a some of deposit box which
work fine. I am trying to create another box next to these boxes called final
balance with a formula of :
=Sum([DepositAmount]-[WithdrawalAmount])

I have used a text box and the above formula in the expression builder but
the text box i inserted does not even appear when i do a review.

 

[Al Camp]

JK,
Here's a bit of an epiphany that most new users eventually come across.
Sum(DepositAmount) - Sum(WithdrawalAmount)
will work in ANY GroupFooter.

Say your report Grouped by State, City, and Store.
Then... Sum(DepositAmount) - Sum(WithdrawalAmount) entered in the...
StateFooter = totals for each State
CityFooter = totals for each City
StoreFooter = totals for ecah Store

In your case, use the CountryFooter.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


A thing of beauty eh??

That worked Great!!!! Now i have to ask since the report has a grouping per
account name, there is a sum for the deposit column and a sum for the
withdrawal column for each each group name. How do i add balance to each
group so it shows a running balance per group name?
ACCT NAME DEPOSITS WITHDRAWALS BALANCE
RUSSIA 1000.00 500.00
1000.00 100.00
SUM 2000.00 600.00 1400.00

INDIA 600.00 100.00
SUM 600.00 500.00

Does the above help describe what i guess is a per group running balance ?
Thanks

I can't say why it doesn't even show. It should , but will probably be the wrong
calculation.
It should be...
= Sum(DepositAmount) - Sum(WithdrawalAmount)

If you could indicate a few sample lines from the report, (what you have vs what you
want to see)...that would help.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

In my report i have a sum of withdrawal box and a some of deposit box which
work fine. I am trying to create another box next to these boxes called final
balance with a formula of :
=Sum([DepositAmount]-[WithdrawalAmount])

I have used a text box and the above formula in the expression builder but
the text box i inserted does not even appear when i do a review.

 

[jk]

Thanks for helping out a new user and i should have figured it out
myself.....It works great!

JK,
Here's a bit of an epiphany that most new users eventually come across.
Sum(DepositAmount) - Sum(WithdrawalAmount)
will work in ANY GroupFooter.

Say your report Grouped by State, City, and Store.
Then... Sum(DepositAmount) - Sum(WithdrawalAmount) entered in the...
StateFooter = totals for each State
CityFooter = totals for each City
StoreFooter = totals for ecah Store

In your case, use the CountryFooter.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


A thing of beauty eh??

That worked Great!!!! Now i have to ask since the report has a grouping per
account name, there is a sum for the deposit column and a sum for the
withdrawal column for each each group name. How do i add balance to each
group so it shows a running balance per group name?
ACCT NAME DEPOSITS WITHDRAWALS BALANCE
RUSSIA 1000.00 500.00
1000.00 100.00
SUM 2000.00 600.00 1400.00

INDIA 600.00 100.00
SUM 600.00 500.00

Does the above help describe what i guess is a per group running balance ?
Thanks

I can't say why it doesn't even show. It should , but will probably be the wrong
calculation.
It should be...
= Sum(DepositAmount) - Sum(WithdrawalAmount)

If you could indicate a few sample lines from the report, (what you have vs what you
want to see)...that would help.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions



In my report i have a sum of withdrawal box and a some of deposit box which
work fine. I am trying to create another box next to these boxes called final
balance with a formula of :
=Sum([DepositAmount]-[WithdrawalAmount])

I have used a text box and the above formula in the expression builder but
the text box i inserted does not even appear when i do a review.