I'm having a hard time with calculating FTE (Full-time equivalents while including selections).
In calculating FTE, depending on dimension (time) you divide hours worked by 1920 (year), 160 (month), 480 (quarter), etc.
Now, I have a situation where it is possible to have more than 1 year, so therefore, I would say, 2015 and 2016 have been selected, sum hours from both years and then divide by (1920*2).
This makes things complicated when it comes to dynamic calculations.
For instance it is currently September 2016 so if I had that year and month selected I would calculate like so : sum(hours) / 9*160
If I had both 2015 and 2016 and September I would need the FTE of Jan - Sep for both years. Therefore, sum(hours) / (9*160)*2.
I think I have the logic down I'm just having trouble bringing it to life with expression(s). Any ideas?
The second column from the right are the values I need to see. I need to see the ratio of Hours to Employed Hours (Hours / Employed) with a rolling sum from the numbers above.
The first three columns are correct. However, if I select May I will not get the right Hours / Employed ratio because it is not taking into account the rolling sum (the previous month's hours accumulated). I want to be able to select May and still retain the correct hours and employed hours respectively 9965.19 and 800 without having to include the other selections (essential it performs a rolling sum whether or not the other periods are selected)
