Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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