Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have an expression (see below)
sum({<Bol_ID-={'003'}>} aggr(distinct max({<Bol_ID-={'003'}>} Artikel.Lagersaldo) *
(max({<Bol_ID-={'003'}>} [Artikel.Vägt inpris] )) ,Artikel.ArtikelNr))
Ontop of this expression i would like to * by a currency see below
>>
sum({<Bol_ID-={'003'}>} aggr(distinct max({<Bol_ID-={'003'}>} Artikel.Lagersaldo) *
(max({<Bol_ID-={'003'}>} [Artikel.Vägt inpris] )) ,Artikel.ArtikelNr)) * BAS_CROSS_inv_FSG_KURS;
However this calculation is not working;
Help is greatly appreciated.
Best
Brad
Sorry bracoy to interrupt,
but Mohit do u have any help notes or sticky notes for improving skills on SET Analysis, m very poor in tht,
if i get confused in it i prefer using if else then,
Please share if u hav any
Hi.
unfortunately the calculation at the bottom returns a 0 result;
any ideas?
Best,
Brad
Actually what i was thinking we could do is isolate this in the expression, however my syntax is wrong could you point me in the right direction, thanks for your help so far;
= [Artikel.Vägt inpris] * BAS_CROSS_inv_FSG_KURS
sum({<Bol_ID-={'003'}>} * BAS_CROSS_inv_FSG_KURS={'**'},aggr(distinct max({<Bol_ID-={'003'}>} Artikel.Lagersaldo) *(max({<Bol_ID-={'003'}>} [Artikel.Vägt inpris] * BAS_CROSS_inv_FSG_KURS)) ,Artikel.ArtikelNr))
Best,
Bradley