Syntax adding calculation to set analysis expression

[#1]

Hi i would like to add an Exchange rate to the following formula.

sum({<Bol_ID-={'003'}>} aggr(distinct max({<Bol_ID-={'003'}>} Artikel.Lagersaldo) * max({<Bol_ID-={'003'}>} [Artikel.Vägt inpris]),Artikel.ArtikelNr))

currency field name - BAS_CROSS_inv_FSG_KURS

Desired result, however i am recieving wrong syntax.

sum({<Bol_ID-={'003'}>} aggr(distinct max({<Bol_ID-={'003'}>} Artikel.Lagersaldo) * max({<Bol_ID-={'003'}>} [Artikel.Vägt inpris] * BAS_CROSS_inv_FSG_KURS),Artikel.ArtikelNr)) -

[Anonymous · Accepted solution]

Should the BAS_CROSS_inv_FSG_KURS be nested along with the max([Artikel.Vägt inpris]) ?

How about ...

sum({<Bol_ID-={'003'}>} aggr(distinct max({<Bol_ID-={'003'}>} Artikel.Lagersaldo) *

(max({<Bol_ID-={'003'}>} [Artikel.Vägt inpris]) * BAS_CROSS_inv_FSG_KURS),Artikel.ArtikelNr))

Jonathan