Suppose you already have a resource with a field for the number of guests. For example, an hourly resource priced at $100 per hour.
Next, create a pricing component to add an extra charge for each guest beyond 8.
Enter a name for the component. To build the formula, insert the parameter for the "number of guests" field — F1.
Multiply $100 by the number of guests exceeding eight. Then, multiply the result by the number of reserved hours. To do this, insert another parameter for the number of hours — STEPS.
100 * ([F1] - 8) * [STEPS]
The formula will return a negative value if the number of guests is less than eight. To prevent this, click the Add condition button and set the minimum number of guests to 9. Now, the pricing component will only apply if there are 9 or more guests. Save your changes.
You will have the following configuration:
Let's test it. Select 2 hours and 11 guests.
Formula: 100 * (11-8)*2 = $600.
See the example in action below.