conditional sum 1

[klaidlaw]

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!!!

 

[lbass]

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

 

[klaidlaw]

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!

 

[lbass]

You'd better see how {WorkCenter.WorkCenterID} displays if you place it in the detail section.

-LB