SumIF

[isateng]

New to FM and a novice. I have a field tracking Defect Class, i.e. Critical, Major & Minor and another filed tracking # of finding. I want to sum these findings based on class. I tried If (class="critical", Sum (# of finding),0) but it didn't work. Will appreciate if someone can help.

[bcooney]

Sounds like you need a summary report, grouped by Defect Class.

Create a field, type summary, called Count_Defect. Set it to equal the Count of the primary RecID.

Then, create a report that includes a sub-summary part when sorted by Defect Class. Place the summary field in the sub-summary part and SORT BY DEFECT CLASS.

For further info, see FM KB