calculate stock per article, but only locations starting with the same letter

[chriscools]

Hello,

can i adapt the expression below to only take into account Locations where the "LocationName" starts with the letter "K"?

sum ({< WarehouseName = {'WHS BE'}, LocationFunction={'PICKING','BULK'}>} StockQty )

Thanx!

Chris

[Gysbert_Wassenaar · Accepted solution]

sum ({< WarehouseName = {'WHS BE'}, LocationFunction={'PICKING','BULK'},LocationName={'K*'}>} StockQty )

[brijesh1991]

if(wildmatch(LocationName,'K*'),

sum ({< WarehouseName = {'WHS BE'}, LocationFunction={'PICKING','BULK'}>} StockQty ))

OR

sum ({< WarehouseName = {'WHS BE'}, LocationFunction={'PICKING','BULK'},LocationName={'K*'}>} StockQty )

[chriscools]

thanx! this works fine!