Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Just guessing, could you add [] around?
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)))