How to Create Custom Formulas in VeriClock Reports

Learn how to create custom formulas in VeriClock reports to calculate values not included in the standard data model, such as mileage, premium pay, or blended labor costs. This guide explains how to build report formulas using punch hours, wages, employee and job data, custom numeric fields, and arithmetic operators to extend reporting and support advanced payroll and cost analysis.

In some cases, a customer may want to include additional data in a report that is not saved a part of VeriClock’s standard data model.  An example is a report that shows Mileage Reimbursement Amount (i.e. the number of kms driven for a shift multiplied by a reimbursement rate (i.e. $0.50/km)

How to create a formula

Step 1 - In ‘Customize’ report, scroll to the bottom of the “Displayed Fields” list and click ‘Create’

This will open the formula creation modal.

Step 2 - Name Formula - it must be unique and can only contain letters, numbers, dashes(-), underscores(_) and spaces.

Step 3 - Create formula using Available Fields

Available Fields -

• punchHours([“optional”])
• punchHours() - returns hours in a given shifts after any global rounding and adjustments
• punchHours(“regular”) - returns only regular hours (as determined by Company’s overtime settings) after any global rounding and adjustments
• punchHours("Overtime 1") - returns only Overtime 1 hours (as determined by Company’s overt time settings) after any global rounding and adjustments
• punchHours([“timeLabel”]) - returns only hours of a given type (as determined by Company’s overt time settings) after any global rounding and adjustments
• punchMinutes([“optional”])
  • Same as above but minutes instead of hours

• wage(“timeLabel”) - employee’s wage for a given time type as set up under the employee’s profile → Payroll Item Settings
• empInfo([value]) - this returns the values set for each employee under the profile - use 1, 2 or 3 as applicable

-----

 

• jobInfo([value]) - this returns the values set for each employee under the profile - use 1, 2 or 3 as applicable

• customField("Field Name") - returns a custom field's numeric value. The quotes " are required and the Field Name must match exactly one of your existing numeric custom fields.  Text and List fields are not available in a custom formula.  See additional information here

 Available operators - Custom formulas are + (addition), - (subtraction), * (multiplication), / (division)

Example #1

In order to calculate a special rate to pay employees that is 1.3 x the regular rate for all regular hours: 

= punchHours("regular")*wage("regular")*1.3

Example #2

In order to calculate the sum of overtime 1 hours and overtime 2 hours: 

= punchHours("Overtime 1") + punchHours("Overtime 2")