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

conditional sum 1

Status
Not open for further replies.
klaidlaw

klaidlaw

Programmer
May 28, 2008
140
US
I need to make a formula that sums the {Routers.RunTime} when the {WorkCenter.WorkCenterID} says Motor. I can't use a running total because it needs to be placed in the group header, and it only works when in the footer. I have CR 10 if anyone could help that would be great thanks!!!
 
Sort by date Sort by votes
Create a formula and place it in the detail section.

if {WorkCenter.WorkCenterID} = "Motor" then
{Routers.RunTime}

Right click on the formula and insert a sum at the group level. Then drag the result into the group header.

-LB
 
Upvote 0 Downvote
When I put it in the details section they were all equal to zero so the the sum was as well...do you have any other ideas? thanks for the help!
 
Upvote 0 Downvote
You'd better see how {WorkCenter.WorkCenterID} displays if you place it in the detail section.

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J33
  • Locked
  • Question
Subreport, subtract from sum
Replies
2
Views
143
hilfy
hilfy
J33
  • Locked
  • Question
Calculate sum when project phase starts with a specific digit
Replies
1
Views
112
lbass
lbass
NBVC
  • Locked
  • Question
Passing sum from subreport to main report details, then hiding details based on that value 1
Replies
12
Views
327
NBVC
NBVC
meagain
  • Locked
  • Question
Conditional and Right Trim formula
Replies
4
Views
168
meagain
meagain
trwebster
  • Locked
  • Question
Summary on non-recurring field error
Replies
1
Views
99
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top