7 Replies Latest reply on Jul 20, 2016 8:55 AM by Muhammad Khan

# Weekly and Hourly salary rates

Hello

I have one column which contains three types of rates- monthly, weekly & hourly. I need weekly and hourly rates of each entry, is there any way to do it.

Example

Employee Name   Salary

Employee A          \$12

Employee B          \$ 600

Employee C          \$2000

I want it in bellow order

Employee Name  Hourly rate      Weekly Rate

Employee A          \$12                     480

Employee B          \$ 15                    600

Employee C         \$ 12.5                  500

Thanks

Muhammad

• ###### 1. Re: Weekly and Hourly salary rates

I think you just need the hourly rate for each employee. Then you can calculate the weekly and monthly rate by setting up calculated fields in your workbook.

Otherwise, you will need to have another column (something like "Rate Type") to describe each entry under Salary.

• ###### 2. Re: Weekly and Hourly salary rates

Hello Naveen

Thank you so much for your response, you are right i already have another column "Rate Type" but I want hourly and weekly rate for every employee. In case I want hourly rate for each employee so how can i make a calculated field because I have four types of values in it- hourly, weekly, monthly and annually. kindly let me know if you know any specific formula.

Regards

Muhammad

• ###### 3. Re: Weekly and Hourly salary rates

Can you post your workbook?

• ###### 4. Re: Weekly and Hourly salary rates

Hi Naveen

That will be difficult because it have some personal information of employees.

Thanks

• ###### 5. Re: Weekly and Hourly salary rates

You can create 2 calculations for hourly and weekly rates.

Hourly:

if attr([Rate Type]) = 'Hourly' then sum([Salary])

elseif attr([Rate Type]) = 'Weekly' then sum([Salary])/40

elseif attr([Rate Type]) = 'Monthly' then sum([Salary])/160

end

Weekly:

if attr([Rate Type]) = 'Hourly' then sum([Salary])*40

elseif attr([Rate Type]) = 'Weekly' then sum([Salary])

elseif attr([Rate Type]) = 'Monthly' then sum([Salary])/4

end

Double click on both new calcs to bring it on the view. You don't necessarily have to attach your original dataset. You can always mock something up in excel to show your scenario. Hope this helps!

3 of 3 people found this helpful
• ###### 6. Re: Weekly and Hourly salary rates

Hi Pooja

Thank you so much for your detailed response. It really worked and I appreciate your help.

Regards

Muhammad

• ###### 7. Re: Weekly and Hourly salary rates

Hi Pooja

I am facing following problems in getting accurate results.

1) I have two rate for salary- "starting" and "final" so i have created another filed called Avg salary but in some cases the stating salary is zero which effects my calculations. I want to ignore "starting salary" if it is zero.

2) I have another field called "Hours per week"  but in some fields it is zero, I want to use 40 as average if there is zero but I am not sure how to do it.

For better understanding i have attached sample work for you.

your help will be highly appreciated

Regards

Muhammad