I need explaination on why it was not working before as all equations seems alright.
Here is my explaination, for why it should have worked without issues
In my example, i have one unique id which is present in both batches. And that Unique id has two sitting info i.e 11 and 1 for each batch. Then in expression i am telling it to give sitting id where sitting info is only when = 11. So this should have worked by showing two rows for two batches with respective sitting id's. and Why it was showing duplicate values.