sum with set analysis with different conditions

[chriscools]

Hello,

i'm trying to make a tabel with stock per article, but only for certain warehouses.

my formula is this:

sum ({< WarehouseName = {'WHS BE','Kontich'}>} StockQty )

but i need an extra condition, showing me for these warehouses only the locations where LocationFunction=Picking and Bulk.

how do i include an extra set analysis? or what is the right way to do it?

and is there a limitation to the conditions you can build in?

can anybody help me?

thanx

Chris

[sebastiandperei · Accepted solution]

Hi Chris!

No, there aren't limitations in the conditions of Set Analysis.

Try with:

Sum( {<WarehouseName = {"WHS BE", "Konitch"}, LocationFunction = {"Picking","Bulk"}>}StockQty)

[chriscools]

thanx, this is what i needed!

grtz,

chris