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

Sum fields with condition

Status
Not open for further replies.
fredong

fredong

IS-IT--Management
Sep 19, 2001
332
US
I am trying to SUM totalsale by certain vendor by creating a formula call @CertainVendorsTotal

below is my syntax and I appreciate if someone can help me. Thanks.

Sum({sp_rpt_Vendor;1.InvTotal}, ({@CertainVendorsTotal} in ["HHH",KKK","GGG"]))



sp_rpt_Vendor is a store procedures name

 
Sort by date Sort by votes
Use a Running Total, and in the evaluate use a formula place:

{table.field} in "HHH",KKK","GGG"}

-k
 
Upvote 0 Downvote
Slight correction to SV's formula for the running total evaluation area (I think the brackets didn't get processed correctly when posted):

{table.vendor} in ["HHH",KKK","GGG"]

You might also be able to create a formula for the detail section like:

if {table.vendor} in ["HHH",KKK","GGG"] then {table.amount}

Then insert a summary on the formula at the group level.

-LB

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

duquane
  • Locked
  • Question
crystal 8.5 compatible with sql 2008?
Replies
0
Views
285
duquane
duquane
garban
  • Locked
  • Question
Is Seagate Info 7.5 compatible with SQL Server 2005?
Replies
4
Views
272
garban
garban
cementcarver
  • Locked
  • Question
Crystal 8 - Working With Maps
Replies
3
Views
195
Maximizer
Maximizer
mwhalen
  • Locked
  • Question
Seagate Info 7 compatible with higher versions of Crystal Reports?
Replies
3
Views
256
synapsevampire
synapsevampire
fredong
  • Locked
  • Question
sum it and group by with a wild card value
Replies
2
Views
149
fredong
fredong

Part and Inventory Search

Sponsor

Back
Top