Forum Discussion

Tomhayw's avatar
Tomhayw
Helper I
3 years ago

Using data from a specific time period

Hi there,    I'm currently running some analysis on how much costs are acrued on a project (people costs only).   This is calculated by hourly rate x number of hours worked on that project.   I...
Need Help
Tomhayw's avatar
Tomhayw
Helper I
3 years ago

Thanks, makes sense.

 

How would I incorpate using the correct rates at the correct time.

E.g. If someone's rate was £40 in 1/1/22 and a project started on 2/1/22, how would I link the two so the project knows to use the rate of £40?

tevisyauw's avatar
tevisyauw
Helper I
3 years ago

emm, it will be case by case base on your client company.
ex 1 : Andy rate was 40 in 01 Jan 2022 - 31 March 2022
and project last from 02 Jan 2022 - 25 March 2022

Then it will be only have 1 rate

ex 2 : Andy rate was 40 in 01 Jan 2022 - 31 March 2022 and the rate change to 42 in 01 Apr 2022 - 30 Jun 2022.

The project last from 02 Jan 2022 - 15 May 2022.

in my case i will average the rate between 02 Jan 2022 - 31 March 2022 (£40), and 01 Apr - 15 May 2022 (£42)

but IF the wage of the employee was project based then they will only use the first (£40) from 02 Jan 2022 - 15 May 2022