3 Replies Latest reply: Jun 7, 2013 3:52 AM by Bradley Coyne

Syntax Set analysis - calculation

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

• BAS_CROSS_inv_FSG_KURS

>>

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

• Re: Syntax Set analysis - calculation

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

• Re: Syntax Set analysis - calculation

Hi.

unfortunately the calculation at the bottom returns a 0 result;

any ideas?

Best,

• Re: Syntax Set analysis - calculation

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,