New to Reporting services 1

[Gramm]

I am trying to create a calculated field that uses a nested if statement and calculates a payincrease. Example:

If year(today)- year(hiredate)< 5 then salary*.05
else If year(today)- year(hiredate)> 10 then salary*.08
else salary*.07 Reporting services tells me I have an error.

I have used this calculations in other programs so it must be something about the syntax in ReportingServices.

 

[SQLBI]

HI,

You need to use an Inline IF statememnt:

=IIF(YEAR(Today)-YEAR(HireDate)<5,Salary*0.05,IIF(YEAR(Today)-YEAR(HireDate)>10,Salary*0.08,Salary*0.07))

Hope this helps.

Cheers,
Leigh

The problem with common sense is that it isn't that common!