Set inside a set

[ferha_jafri]

Hello Everyone,

I need help in writing an expression in which I want exclude POL1,POL3,POL4 for location 3704  in a way that I should get the remaining one. Eg total mailpiece count is 9 and exclusion is 2 so and should be 7. Attaching the sample.

Thanks in advance

Ferha Sharma

[ferha_jafri]

Thanks  Tresesco , I understood the expression but did not understand the reason which you gave, it would be helpful if you elaborate it more ,as why the condition cannot be implemented as I want it to implement.

[tresesco · Accepted solution]

If you exclude POL1,POL3,POL4 and sum it, it actually sums for rest (selected in screenshot 1) of the Pre_Adv_Customer which is like in case 1 in screenshot that doesn't give you 7. If you fix the selection of Omc_location_id to '3704' then the sum becomes 1( screen shot 2), because only one from rest members of Pre_Adv_Customer is relevant to it (refer 2 and 3).

Hope this helps.