Conditional Sum in Report

[Jovix]

Hello,

lets say I have two columns, one has a Cost Type such as MaterialCost, ShippmentCost, LaborCost, etc... and the other column contains the actual cost amount for that cost type. Can I Sum the CostAmount column based on criteria from the CostType Column. For example.

I would like to sum only the LaborCost Amounts.

If I were to write this out in code it might look like this.

Sum CostAmount WHERE CostType = LaborCost

or

IF CostType = LaborCost then
Sum CostAmount
End IF

Thanks in Advance
J