March 26, 201114 yr Newbies 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.
March 26, 201114 yr 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
Create an account or sign in to comment