Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running totals

Status
Not open for further replies.
CRAMan

CRAMan

Technical User
Dec 11, 2001
33
US
Ok I have a running total averaging the commission of deals if they have the right code.

Each code has its own running total.

In the summary page I want to show 0’s for codes that had no deals.

If I use a simple isnull formula on the running total it doesn’t give me anything.

Help?

 
Sort by date Sort by votes
I don't understand. If you have a running total for a code and it finds nothing for a code, it should display zero if you put that running total in your report footer. How does isnull come into it?

Also what version of Crystal are you using?

Madawc Williams
East Anglia, Great Britain
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
390
doodledump
D
jlr123
  • Locked
  • Question
Crystal Formula Grand Total - Running total 1
Replies
2
Views
117
jlr123
jlr123
Paulo R
  • Locked
  • Question
CR Running Total distinct count duplicates
Replies
9
Views
202
Paulo R
Paulo R
BradCustom
  • Locked
  • Question
Running total on variable 1
Replies
3
Views
120
BradCustom
BradCustom
PhilG1
  • Locked
  • Question
Cumulative Running total query
Replies
1
Views
101
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top