Crystal Sum on field value

How do I sum a specific field based on values in some other column. I am trying to do - Sum of Annual Costs (Column to be summarized) where Cost type (Column field the summary is to be based upon) = Equipment Costs.开发者_如何学运维 Thanks

This is nearly identical to your other question; create a formula that does the following:

if ({YourReport.CostType} = "Equipment Costs") then 
    {YourReport.AnnualCosts} 
else 
    0 

And then create a summary on this formula.