Desktop productivity for business analysts and programmers

Case function to create brackets

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 104
Accepted Solution

Case function to create brackets


Hi, can some one help me on this case function. I'm trying to create a new calculated column and employee hired between two dates, they get bonus based on the dates range I set.

Case

When  date(01/01/1976)<=t1.Employee_Hire_Date<=date(12/31/1985) then t1.Salary*.001

else t1.Salary

end


Accepted Solutions
Solution
‎09-23-2014 09:13 PM
Respected Advisor
Posts: 3,069

Re: Case function to create brackets

Try this:

Case

When  "01/01/1976"d <=t1.Employee_Hire_Date<= "12/31/1985"d then t1.Salary*.001

else t1.Salary

end

View solution in original post


All Replies
Solution
‎09-23-2014 09:13 PM
Respected Advisor
Posts: 3,069

Re: Case function to create brackets

Try this:

Case

When  "01/01/1976"d <=t1.Employee_Hire_Date<= "12/31/1985"d then t1.Salary*.001

else t1.Salary

end

Trusted Advisor
Posts: 1,203

Re: Case function to create brackets

Based on your logic looks like you are trying to add bonus amount in salaries for the employees hired between the specified dates. So end variable will be salary again.

Case

When  "01Jan1976"d <=t1.Employee_Hire_Date<= "31Dec1985"d then t1.Salary*1.001

else t1.Salary end as Salary;

Otherwise, if need a bonus variable then

Case

When  "01Jan1976"d <=t1.Employee_Hire_Date<= "31Dec1985"d then t1.Salary*0.001

else 0 end as Bonus;

Frequent Contributor
Posts: 104

Re: Case function to create brackets

Thank you.  It worked.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 282 views
  • 3 likes
  • 3 in conversation