if Statement Expression

Thu, 16 May 2013 21:48:00 GMT

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

Re: if Statement Expression

Thu, 16 May 2013 21:59:16 GMT

This may work:

sum(if(Bol_ID = '000' or Bol_ID = '001', Aggr(DISTINCT Max(Artikel.Lagersaldo) * Max([Artikel.Vägt inpris]),Artikel.ArtikelNr )))

Hope that helps.

Matt