The service transformation expression topic allows you to modify the service otherwise calculated by way of a free-form expression using ProAdmin built-in operators and database fields. Check the Transform service box to indicate that service is to be transformed by an expression.

The Expression box allows you to use Data Dictionary fields and ProAdmin built-in operators, including #DATE and #THIS, to determine service. See expression operators, or press F1 from within the box, for details about the operators available, which range from simple arithmetic to specialized measurement period and date arithmetic operators. In the context an elapsed time service transformation, #THIS represents the elapsed time service calculated prior to any transformation.

For example, if the elapsed time parameters define service as the difference in calendar days assuming 365 days per year, but the plan assumed 365.25 days per year (an option not currently available in the Elapsed time parameters topic), the following expression would transform the previously calculated service to the correct value:

 (#THIS * 365.25) / 365

Elapsed time transformation expressions are applied after the elapsed time service has been determined, reflecting start and stop adjustments and any multiplier, but before the addition of any prior event service, application of a service rounding rule or recognition of grandfathered service.

Examples of service transformations:

Projecting hours using the previous 12 months
Projecting hours but limiting annual service
Transformation expressions details