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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert a total for certain data excluding other data

Status
Not open for further replies.
mvalley

mvalley

Technical User
Mar 4, 2011
80
US
I have a report that has a field that has 2 responses, YES or NO.
This report has 14 entries, 8 YES and 6 NO
I need to insert a total for all YES response so that 8 is in the footer. How is the best way to do this?
 
Sort by date Sort by votes
Use a formula and then sum that

If ResponseField = 'YES' then valuefield else 0

Ian
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
436
mmck1964
mmck1964
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
550
doodledump
D
Cpreston
  • Locked
  • Question
Only Select certain rows 1
Replies
7
Views
421
Cpreston
Cpreston
SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
317
SarahSCPDAdmin
SarahSCPDAdmin
jlr123
  • Locked
  • Question
Crystal Formula Grand Total - Running total 1
Replies
2
Views
201
jlr123
jlr123

Part and Inventory Search

Sponsor

Back
Top