Custom column to exclude Time Off hours in Pay Rate calculation
Find resources designed to help you get the most from Replicon
To generate a column that will show the Amount for Total Hours a person has worked against his Base Payroll Rate. This calculation should not take into consideration the number of hours for any time off type.
Create a Report with the required columns. In the custom column, provide the below given formula:
The above formula takes advantage of the fact that all time off types fall under ' <None> ' Project Name. So whenever the formula encounters no project name, it will not multiply the hours with base pay roll rate.