check whether Machine Runlot information exists in Machine FA

[Sxbbb]

I want to check whether Machine Runlot information exists in Machine FA or not. 

If Machine Runlot does not exist in Machine FA, count Base WOrk Output.

[LRuCelver]

You can use SubStringCount to check whether a substring exists in a string.

[Sxbbb]

I tried it and it's correct. But I want to count Base Work Output which is 0 and QTY FA = 'N/A '. 

I want the sum count Base Work Output

I tried but it's not correct.

[LRuCelver]

I'm assuming the column "Base WOrk Output" is the field "WorkOrder_BaseOutput".

Since it is a dimension in the table, the count distinct will always return 1. If you want to count the number of times the combination of dimensions appears in you data, drop the distinct from your expression. You might also consider adding the else-case to the if statement if it is wanted.

If my assumption is incorrect, please provide some sample data and a mockup of what the result should be, given the sample data.

[Sxbbb]

Yes, I would like to know how many Base Work Outputs that Machine Runlot does not have in Machine FA.

What do I have to do?

[LRuCelver]

Removing "distinct" from the count might be enough, depending on your data.

[Sxbbb]

Invalid value I need to put the values ​​in a summary table.

[LRuCelver]

Can you please share a small data sample as well as how and with what dimensions you need to calculate the values?

[Sxbbb]

Machine FA :

Machine Runlot :