want to count Base WOrk Output where SubStringCount =0 and QTY FA = 'N/A' .Table Summary

[Sxbbb]

I Have Data 

Machine FA :

Machine Runlot :

column "Base WOrk Output" is the field "WorkOrder_BaseOutput".

I want to count Base WOrk Output where SubStringCount =0 and QTY FA = 'N/A' .Table Summary 

I tried and the value is incorrect.

Both codes are the same, incorrect.

want to count Base WOrk Output where SubStringCount =0 and QTY FA = 'N/A' .Table Summary 

[qv_testing]

if you have two fields in same table, calculate substringcount script level.

your expression will be like

COUNT({<SubstringCount={0}, QTY FA = {'N/A'}>}WorkOrder_Baseoutput) 

[Sxbbb]

Error Expression 

[qv_testing]

QTY FA should be in SQUARE bracket [QTY FA]

[Sxbbb]

It counts every Base WORK Output, it is incorrect.

Just want to count (SubStringCount([Machine FA],[Machine Runlot])) = 0

[qv_testing]

can you share sample data ?

[Dataintellinalytics]

As suggested by "Qv_testing" did you move the substring logic to backend data load editor script and created calculated field SubstringCount ?