Forum Discussion

Psycho's avatar
Psycho
Frequent Visitor
9 years ago
Solved

Creat a comparative conditions

Hello together!   I have a question for the creation of certain conditions.   I want to calculate following, but i dont know the syntax:   02 Dur.Bestmge.AktJ = if(Tabelle1[Monat] = "End.Best...
Need Help
  • mpo's avatar
    mpo
    9 years ago

    If I understood you correctly, try

     

    02 Dur.Bestmge.AktJ = if(Tabelle1[Monat] = "End.Best.Mge.AktJ 02",
       Tabelle1[Bestand]+LOOKUPVALUE(Tabelle1[Bestand],
         Tabelle1[Artikelnummer],Tabelle1[Artikelnummer],
         Tabelle1[Monat],"End.Best.Mge.AktJ 01"),0)
mpo's avatar
mpo
Helper II
9 years ago

If I understood you correctly, try

 

02 Dur.Bestmge.AktJ = if(Tabelle1[Monat] = "End.Best.Mge.AktJ 02",
   Tabelle1[Bestand]+LOOKUPVALUE(Tabelle1[Bestand],
     Tabelle1[Artikelnummer],Tabelle1[Artikelnummer],
     Tabelle1[Monat],"End.Best.Mge.AktJ 01"),0)
Psycho's avatar
Psycho
Frequent Visitor
9 years ago

Yes, that´s what I want. Wonderfull. Thank you very much.