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

sum if 1

Status
Not open for further replies.
ibearian

ibearian

Technical User
Jul 4, 2001
131
GB
is there a simply way to do and excel style sumif. i know about formulars to create values based on a 'if' critea and then summing them, but sumif would be much easier.

thankyou

 
Sort by date Sort by votes
There is no SumIf in crystal. The 2 best solutions to this are an if-then formula, and then sum it as you suggested, or a running total field evauated by a formula.

To create a RT field, insert-field object-running total field, name the field to sum, evalaute based on formula, enter your formula and reset=never or reset=change of group, as the case may be. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jlr123
  • Locked
  • Question
If field is Null 1
Replies
3
Views
172
kray4660
kray4660
J33
  • Locked
  • Question
Subreport, subtract from sum
Replies
2
Views
142
hilfy
hilfy
J33
  • Locked
  • Question
Calculate sum when project phase starts with a specific digit
Replies
1
Views
109
lbass
lbass
Bloke152
  • Locked
  • Question
Suppress section if field is null
Replies
2
Views
440
hilfy
hilfy
supportsvc
  • Locked
  • Question
Combine Multiple If Statements as Single String? 1
Replies
7
Views
311
supportsvc
supportsvc

Part and Inventory Search

Sponsor

Back
Top