Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
Thanks
Hi,
You can achieve this using set analysis
count({<Status={'PASS'}>} Unit_ID)
Hi,
You can achieve this using set analysis
count({<Status={'PASS'}>} Unit_ID)
Hi,
Please find the attachment.
Regards
Neetu Singh
U can also use:
Expression:
COUNT(if(Status='PASS',[Unit Id]))
Thanks Shans My problem is solved