move expression into the script

[#1]

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,

[#2]

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