This content has been marked as final. Show 4 replies
I have 2 fields in a same table
Field 1: Unit_ID
Field 2: Status
Unit_ID gives the unit id's processed in the plant.
and status give the various status of the operation applied on the perticular unit. status are PASS,FAIL,ERROR
I want to calculate the no of units for which the status is PASS.
Please suggest me the expression for that.