Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i have a rather complex expression i wish to move into my script.
i have attached the qvw to this message.
the expression i am looking to move is the following
sum({<Bol_ID-={'003'}>} aggr(distinct max({<Bol_ID-={'003'}>} Lagersaldo) *(max({<Bol_ID-={'003'}>} [Vägt Inpris])) ,ArtNr));
your help is greatly appreciated;
bradley,
Try using another table for the calculation in the script, like this one
MyTable:
LOAD Distinct
Artikelkat,
Max(Lagersaldo) * Max([Vägt Inpris]) AS Expr
Resident Article
Where Bol_ID <> '003'
Group By Artikelkat;
Maybe you are looking for Max(Lagersaldo * [Vägt Inpris]), but I am not sure.
JG