How to Calculate Discounted Unit Price on Line Items

HubSpot’s line item editor is powerful, but it can be confusing when you start mixing discounts, percentages, and calculated properties. It gets even more confusing when something works perfectly in the property test and line item editor, then mysteriously behaves differently in your quote or estimate.

This hack walks through how to build a discounted unit price calculation that actually works with percentage discounts on line items, and what you can realistically expect when you try to show that value on quotes or estimates.

Why is this hack helpful?

If you sell anything with discounts, you have probably hit at least one of these:

• You want to store the unit price after discount as its own property for clarity.
• Your formula makes sense on paper, but returns weird results when people type in a percentage.
• The calculation works beautifully in the property test but does not behave in the quote/estimate template the way you expect.

This hack helps you:

• Use the right line item properties for discounts.
• Build a reliable calculation for discounted unit price.
• Understand why the property appears in the editor, but not in your final template, so you are not wasting time thinking the formula is broken when it is actually a template limitation.

Perfect for anyone managing products, quotes, or pricing in HubSpot who wants precision without faffing around in spreadsheets.

Steps to Set it Up

Step 1: Understand how HubSpot handles discounts on line items

Before you write a single formula, you need to know what HubSpot is actually doing under the hood.

On line items, HubSpot supports both:

• Unit discount amount
  • Treated as a currency value (e.g. 10 = $10 off per unit).
• Unit discount percentage
  • Treated as a numeric value shown as a percentage (e.g. 10 = 10%).

In the UI you will see 10%, but HubSpot is storing 10 and treating it as “percent”, which is why you still need to divide by 100 in formulas.

This behaviour is documented in HubSpot’s line item docs, which also explain how percentage and amount values are rounded when discounts are applied.

The important takeaway:

• If you want to work with percentage discounts, use a property that represents the percentage value, not the currency amount.

Step 2: Choose the right properties for your calculation

A common mistake is to write a formula like:

unit price - (unit price * (unit discount / 100))

When unit discount is actually a currency amount, not a percentage. That means:

• If someone types “10” thinking it is 10%, HubSpot can treat it as 10 currency units.
• The property test might still make sense in your narrow test case, but once people start using it live, the maths is off.

Instead, you want:

• unit_price → The original line item unit price.
• discount_percentage → The percentage discount you want to apply at the line item level.

This discount_percentage should be the field that HubSpot shows as 10% in the interface while storing 10 as the value.

Step 3: Build the correct discounted unit price formula

Create a custom calculation property on the Line Item object.

In the formula editor, use:

unit_price * (1 - (discount_percentage / 100))

What this does:

• discount_percentage / 100 converts 10 → 0.10

• 1 - 0.10 gives you the factor to apply to the price (0.90)

So for a $100 line item with a 10% discount:

• discount_percentage = 10
• 10 / 100 = 0.10
• 1 - 0.10 = 0.90
• 100 * 0.90 = 90

The Test button in the property editor should show exactly that.

If it does:

• Your formula is correct.
• HubSpot is handling the percentage as expected.
• You are safe to move on.

Step 4: Add the calculated property to the line item editor

Next, make the property visible where your team actually works with line items.

1. Open a deal, quote, or estimate where you have a line item editor.
2. In the line items table, click Edit columns (top right of the table).
3. Find your discounted unit price calculated property in the list.
4. Tick the checkbox to add it, then click Apply.
5. Optionally drag it to sit next to:
   • • Unit price
     • Discount/Discount% so it reads like a pricing story across the table.

Now, when users enter a discount_percentage on a line item:

• HubSpot will re-run the calculation.
• Your discounted unit price column will update.
• Everyone sees the right net price at a glance.

At this point:

• • The calculation works.
  • It is visible in the line item editor/estimate construction table.
  • You are using the fields the way HubSpot expects.

Step 5: Why it does not just appear in the estimate or quote template

Here is where things get a bit unintuitive.

There are two contexts:

1. Line item editor/estimate construction table
   • Shows almost any line item property you choose via Edit columns.
   • Includes custom and calculated line item properties.
   • Ideal for internal use and internal clarity.
2. Estimate/quote template
   • Uses a specific line item table module in the template.
   • Only shows fields that the template or module is configured to support.
   • Does not automatically surface every custom line item property.

So even though:

• Your property exists.
• The calculation is correct.
• It is used on the line item editor table.

…it may not be available as a field to drop into the quote or estimate template.

That is a template/module limitation, not a bug in your calculation.

Step 6: Your options for showing it on estimates or quotes

What you can do here depends heavily on your access and setup.

Option A: Customise the line item table in the template

If you have template editing access (for example, via Design Manager or a custom quote/estimate builder):

1. Edit the estimate/quote template you are using.
2. Find the line item table module that renders products and prices.
3. Either:
   • Clone it and modify, or
   • Replace it with a custom line item table module that allows you to configure columns.
4. In that module’s settings, add your discounted unit price property as:
   • A new column, or
   • A replacement for an existing field you do not need.
5. Save and re-publish the template.
6. Test with a fresh estimate/quote so you are sure the new field appears.

This is the cleanest way to display custom line item properties, but it does rely on:

• Access to the right template tools.
• A module that supports configuration of line item fields.

Option B: Use it purely as a calculation helper

If you cannot touch templates, you still get value:

• Use the discounted unit price:
  • In the line item editor.
  • For internal QA and approval.
  • As a field in line item reports.
  • In workflows (for example, margin checks, approvals, alerts).

In this case:

• You let HubSpot’s own totals render on the quote.
• You use your calculation in the background to keep things accurate and auditable.

Option C: Map into a supported visible field (last resort)

If you absolutely must see the value on the final document and cannot customise templates:

• Use a workflow or automation to write the calculated value into a line item field that is supported by your template.

You need to be careful here, so you do not confuse your team or overwrite important values, but it is a workable compromise if your template options are locked down.

Wrapping Up

You are not going mad: if your discounted unit price formula works in the test tool and in the line item editor, your maths is fine. The awkward bit is the gap between what the line item editor can show and what your estimate or quote template is allowed to render.

By:

• Using a proper percentage field (discount_percentage).
• Writing a clear formula (unit_price * (1 - (discount_percentage / 100)).
• Adding it to the line item editor via Edit columns and understanding the template limits.

You get a robust, reusable way to show discounted unit price where your team actually works, and a clear path if you later want to wire it into templates.

If you want help unpacking:

• Which discount fields you should be using.
• Whether your current templates can actually show this property.
• Or how to design a pricing and discount model that works neatly across quotes, deals, and reporting.

Get in touch with us and we can map this out for your specific HubSpot setup.

Want more HubSpot hacks?
Follow us on Facebook and YouTube. We regularly share walkthroughs, hacks and tutorials so you can get more out of HubSpot without breaking your brain or your data.