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

    Syntax Set analysis - calculation

    Bradley Coyne

      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

      Brad