Expression Set Analysis

[#1]

hi i have the following expression that is attached to a variable;

Sum({$<WarehouseNr={$(WarehouseVariable)}>} Lagernr.Lagersaldo)

the Variable - WarehouseVariable allows me to enter one Value ie.1000

i would like to add a listfield to my analysis now, whereby i can dynamically pass WarehouseNr to the statement.

if i do the following i recieve a list of all the Articles and it is not dynamic

Sum({$<WarehouseNr>} Lagernr.Lagersaldo)

is there a another way to write the statement?

PS i have other columns in the chart that i dont want to effect that is why i am using Set analysis.

Best,

Bradley

[er_mohit · Accepted solution]

try this

Sum({$<WarehouseNr=>} Lagernr.Lagersaldo)

or this

Sum({$<WarehouseNr={"$(=WarehouseVariable)"}>} Lagernr.Lagersaldo)

[#3]

try this

Sum({$<WarehouseNr={'=WarehouseVariable'}>} Lagernr.Lagersaldo)