Overview
Preference Name = CEWHOLENUM
Full Name - Enable some Cost Estimate duration variables to calculate using the rounded number methodology
This preference dictates which calculation methodology is used for the following variables:
Months in Host
Assignment Duration (always whole number)
Total Work-time in Months
The preference will impact calculations that leverage any of these variables (mainly WICE and CE).
Setting the preference to Yes activates the 'Rounded number methodology' (legacy method)
Setting the preference to No, activates the 'Precise calculation method' (decimalizes the first and last month’s calculated values)
Calculation Methodology
Let's use the Assignment Duration variable as an example. Our example Assignment runs from Mar 15th to June 15th:
Ass. Duration = First Month of Assignment + Months in Between + Last Month
Rounded Number Methodology (CEWHOLENUM = Yes)
First Month = 1 month
Each Month in Between = 1 month
Last Month = 0, unless the End Date is Last Day of Month, then = 1
Duration = 1 + 2 + 0 = 3
Precise Calculation Method (CEWHOLENUM = No)
First Month = ((Last Day of Month – Start Date)+1)/Last Day of Month
Each Month in Between = 1 month
Last Month = End Date/Last Day of Month
Duration = ((31-15)+1)/31 + 2 + 15/30 = 3.05 (2DP) which is then rounded to 3
Things to Note
If estimates are re-processed they will respect the current value of the preference. Because of this, it is important to access the possible impact to pre-existing estimates that will be recalculated after this setting is changed.
The host % variable will always be included in the months in host calculation, regardless of this system preference. This means if a work pattern is leveraged in an estimate, it is possible to have a non-rounded number for the months in host value as the host % variable is included into the calculation.
The Assignment duration variable is the sum of Total Work-time in Months (all years). This is the duration of the estimate (which is time spent in host and home) and is sent to the Tax Engine for tax calculation purposes.
The calculated months in host will be rounded to the nearest whole number regardless of system preference selected. This will prevent associated issues with user reports and custom calculations converting this value into an Integer data type.