1 Reply Latest reply: Jun 4, 2013 7:48 AM by Jonathan Brough RSS

    Syntax adding calculation to set analysis expression

    Bradley Coyne

      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)) -