10 Replies Latest reply: Oct 31, 2013 10:06 AM by Clever Anjos RSS

    Nested if statment not working

    Fredrik Wikberg

      Hi

       

      The below if statement is not working. I dont know why. It is only calculating values for the <4 part not the =4 or =5 part.

       

      if([Intervall RD]<'4',[Rörlig Lön]*[Procent RD],

      if([Intervall RD]='4',[Rörlig Lön]*%AvBudget,

      if([Intervall RD]='5',[Rörlig Lön],0)))

      as Utbetalt

       

      I am happy for any help to solve this.

       

      //Fredrik