Set analysis combined with if

[amber2000]

Hello everyone,

I have a set analysis and I want to combine it with an if.

After reading a few discussions on this subject I understand that this is not the way to go (we work with big datasets)

This is my Set Analysis expression:

=Sum({$ <[SD_WH] -= {12}, [Aisle_Zone] -= {PBS_Containers, PBS_Displays}> }[SD_Shipped_Colli])

Now I also want to Exclude values from the sum based on this if statement:

If (Article_FlowType = 'PBS' and (Article_TI * Article_HI = 1 ))

I'm not able to include this in the above expression because I also have an Article_FlowType named 'PBL' with a TI * HI = 1 that needs to be included in the sum.

Can anyone help me with this please? This is above my knowledge.

Kind regards,

Monique

[amber2000]

Thank you for helping me out and I will surely read your attachment.

Kind regards,

Monique

[sunny_talwar]

Not my document. Somebody else created it and I am just sharing it with you