Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
Sum({$<WarehouseNr=>} Lagernr.Lagersaldo)
or this
Sum({$<WarehouseNr={"$(=WarehouseVariable)"}>} Lagernr.Lagersaldo)
try this
Sum({$<WarehouseNr=>} Lagernr.Lagersaldo)
or this
Sum({$<WarehouseNr={"$(=WarehouseVariable)"}>} Lagernr.Lagersaldo)
try this
Sum({$<WarehouseNr={'=WarehouseVariable'}>} Lagernr.Lagersaldo)