if Statement Expression

[#1]

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

[#2 · Accepted solution]

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