How to use Custom Formulas in Pricing

The new Custom Formulas feature allows you to enhance your rate card customization by creating dynamic custom columns. With this update, users can base custom columns, such as priority rates, on calculations derived from other columns or metrics.

Key Features

1. Dynamic Custom Columns: Create formulas to calculate column values dynamically based on existing data.

2. Manual Editing Enabled: Override any formula-based value with manual entries at any time.

3. Daypart-Based Adjustments: Set different percentages for specific dayparts using an easy toggle.

Setting Up Custom Formulas

Accessing the Formula Editor:

1. • Navigate to the settings panel in your rate card.

     

   • Click the "fx" formula icon next to the column name where you want to enable a formula.

     

   Defining a Formula:

   • In the formula editor, you can specify the custom column base value as:

     • A Manual rate you enter.

     • The calculated Planning Rate.

     • A mathematical calculation using an available Custom Column.
       

1. • After setting up the base value, you can apply a percent markup to that value using the Percent input box.

   • Always remember to save your changes!

   Switching Between Formula and Manual Modes:

   • Use the settings panel to toggle between formula-based calculations and manual adjustments for any custom column.

   • This flexibility ensures you can fine-tune rates as needed without restrictions.

   Applying Daypart-Based Percentages:

   • To customize formulas by dayparts, activate the Daypart-based Percentages toggle in the formula editor.

   • Specify unique percentages for each daypart to reflect varying priorities and rates effectively.