Overview
Formula fields in Rocketlane empower teams to create custom calculations directly within reports, eliminating the need for external tools. These fields enable dynamic, on-demand insights, allowing users to capture essential business metrics such as utilization (e.g., productive or billable hours) and profitability. With formula fields, teams can tailor reports to their unique operational needs, ensuring data-driven decisions are both accurate and actionable.

Note: Formula fields are available exclusively with Enterprise plans.

How to Create a Formula Field

Formula fields can be created within custom reports, specifically in tabular reports and pivot tables. To use formula fields:

Add a Formula Field

1. Under the Columns section, click on Add fields.

2. Choose New formula field from the dropdown menu.

Choose the type of formula field to create based on your requirements. Options include:

• Project field

• Task field

• People field

• Role field

• Time tracking field

By default, the formula field type matches the report’s source. For example, if the report source is "Projects," the formula field will be a project formula field.

Proceed to follow these steps to construct the formula:

1. Add the required fields to your formula using the Add fields button.
   Example: To calculate the percentage of billable tracked hours relative to budgeted hours, add fields such as “Tracked hours” and “Budgeted hours.”

2. For fields with a one-to-many relationship (e.g., Tasks, Time Tracking), apply specific filters:

   • Hover over the field (e.g., “Tracked hours”) and click the filter icon.

   • Set conditions to refine the data. For example, filter “Tracked hours” to include only “Billable” hours.

3. Enter a name for the formula and define the formula itself.
   Example: To calculate billable tracked hours as a percentage of budgeted hours, enter the formula: (A/B).

Note: Formula fields support the following operators:

• Addition (+)

• Subtraction (−)

• Multiplication (×)

• Division (÷)

Click Create to save your formula. Once saved, you can add the created formula field to your report by selecting it under Add fields.

Formula fields are versatile and reusable across Rocketlane reports. A formula field created in one report can be added to any other report. They behave like standard fields and support Filtering and Sorting