Condition in Expression

[sushil353]

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

[#2 · Accepted solution]

Hi,

You can achieve this using set analysis

count({<Status={'PASS'}>} Unit_ID)

[neetu_singh]

Hi,

Please find the attachment.

Regards

Neetu Singh

[#4]

U can also use:

Expression:

COUNT(if(Status='PASS',[Unit Id]))

[sushil353]

Thanks Shans My problem is solved