Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thank you for helping me out and I will surely read your attachment.
Kind regards,
Monique
Not my document. Somebody else created it and I am just sharing it with you