Добавление суммы в группу без ее фильтрации в crystal reports

---

I have created a report in Crystal Reports that has work order (WO) information at different levels

Group 1 = Total number of WO's

Group 2 = Total Closed WO's and Total Open WO's

Group 3 = Info on all WO's by group ( open or closed)

This took some learning but I finally got all the counts correct by choosing the sigma icon and doing a distinct count for each group. so all is good.

NOW I need to calculate the cost for each WO. When I do this Only the close WO's show due to the fact that the cost is not calculated for the WO until it is closed.

What I am looking for: Would love for the report to work the same as it did before but now for the closed work orders have the ability to show the cost associated with it with the same effect. Any help would be great

Что я уже пробовал:

What have I tried: For the cost formula I tried the following : if {WORKORDER.STATUS}="Closed" then {WORKORDERCOSTSUMMARY.EQUIPMENTCOST}+{WORKORDERCOSTSUMMARY.LABORCOST}+{WORKORDERCOSTSUMMARY.MATERIALCOST} else 0

---