FTE calculation accuracy improvement

Has this ever been implemented? 

Instead you should create a function that we can call to give us the number of Working Days instead of trying to calculate anything for us.

Function should be like --

     WorkingDays(<FromDate>,<option>,<ToDate>)

<ToDate> - would be OPTIONAL; but if <option>='to' then you know it is FROM TO DATES

<option> - would be things like 'To, 'Previous 3 Months', 'Previous Month', etc

<FromDate> - would obviously be the "starting point" of the calculation

Finally, this would ALL be based on UTC time unless you want to add another final option <timezone> to allow one to select.

We need a function like this to DYNAMICALLY calculate the number of working days based on our Org Calendar, so it can take into account Holidays and other "anomalies". This can then be used to calculate things like Utilization more accurately; because there are BIG differences between WORK LOAD, BILLABLE TIME, REVENUE GENERATING TIME, etc so we need to be able to do some calculations ourselves...

EVERYONE reading this MUST VOTE; otherwise, no enhancements are ever planned and we ALL needs this... 

Hi Wilfredo, 

Please look into using DateSubtract():

Best regards,

Roland

Hey Roland,

    Unfortunately, this function is not available in REPORTS and this is where we need to do Utilization Calculations for displaying to Management.

The nice thing about REPORTS is that they are "dynamic"; but once you start to do all these "heavy calculations", there should be some way to "cache" or "index", because I also get failures on some reports; because we put too many Calculated Fields.

You should be able to add up all the Timesheet durations in a report and then DIVIDE by different Data Calculations; but you "stripped them all out".

Scheduling a job is not acceptable; because that just aggregates values and Managers want to be able to "drill down" in Real-Time.

Hi Wilfredo,

In such case, your best bet is to create a custom field.

Best regards,

Roland