1 Reply Latest reply: May 16, 2013 5:59 PM by matthew thompson RSS

    if Statement Expression

    Bradley Coyne

      hi having trouble with the following logic.

       

       

      My first expression works great however i would like to add the following logic to the statement.

      I have a field for company code and depending on the company code i would like the expression to work,

       

      so for example

       

      if(Bol_ID = '000' or Bol_ID = '001' then do the following (code below)  else show 0.

       

       

      sum(

      Aggr(

      DISTINCT

      Max(Artikel.Lagersaldo) * Max([Artikel.Vägt inpris])

      ,

      Artikel.ArtikelNr

      )

      )

       

      Help is much appreciated.

       

      best,

      Brad