Pricing Table calculations: Excel Formulas.
Enable much higher flexibility in the Pricing Table with Excel-like formulas that allow summing up the columns you like or aggregating a total based on custom rules.
Hi. Thank you so much for reaching out and sharing your perspective. We offer this feature in scope of a broader solution, namely:
We hope these releases can help you. If not, please keep upvoting this idea, so we can keep considering it every time we work on our roadmap.
-
James Cole commented
Can this Feature be added to Templates
-
This feature is available as a part of the paid CPQ for HubSpot add-on. If this is something you're interested in, reach out to your Customer Success Manager or sign up for a demo: https://www.pandadoc.com/lp/hubspot-cpq/
-
Tyson Wiens commented
I cannot find a way to turn on Quote Rules. Can you please provide guidance.
-
Kay van Aarssen commented
The link does not work anymore, is there still access possible to the Early Access? Since your last post was from June... Its now September...
-
Savannah Faulkner commented
Two fees are added to the total. Would like the ability to calculate the second fee based on the first fee
-
Neil Griffin commented
Valeryia, I'd like to get early access and test please :)
-
Nikki Johanna commented
Now you can use the variable Document.Value to get the value of the entire document (or whichever price tables you have checked and wish to include).
However, there is no variable to show the total value of for example price table 1 and 2 and another variable to show the total value of price table 1 and 3.
For quotes to the customer, it would be very helpful to, for example, give him the total price of option 1 (price table 1 and 2) and option 2 (price table 1 and 3) in the same document and have the total price for both options change when you alter said price tables. -
Allie Brittain commented
Our product pricing is quite extensive and clients only need to see the summary.
I'd like to create a table that shows:
1) one time costs
2) annual sum of annual costs
3) annual sum of monthly costs
4) year 1, year 2, and year 3 totals -
Angelica Lapat commented
For example, if we wanted to get an annual amount value derived from the price table's total. We can use the total * 12 and place it into a variable.
-
Paul Rosa commented
This is very important for price table. It will allow to make different calculations based on quantities, discounts and price
-
AdminYana Martynenko (Admin, PandaDoc) commented
Smart tokens
1) the token that illustrates the price of a specific product;
2) Can plus to each other and sum up to be the same as total amount in the pricing table. -
Savannah Faulkner commented
Calculation for custom fields (added from catalog) in a pricing table or quote builder
-
Alison Henry commented
Our team is looking at other contract solutions that can support this. It is absolutely critical but does not seem to be moving forward.
-
Khurram Nazir commented
A must have for the business, please add asap.
-
Jason Morriss commented
Please add functionality to record deposits or partial payments and a resulting final balance. This could be accomplished with formulas, but making it standard would be great
-
Connor Smith commented
This would improve efficiency for us.
-
Lucidity Sales commented
Please allow variables in pricing tables as a bare minimum. We need to be able to add up individual tables into an executive summary.
-
Joris de Boer commented
Simple formulas in a pricing table would be absolutely a big plus.
-
Red Safety commented
I'm looking for this as well. Just saying!
-
Alison Henry commented
This is so critical for so many. Please add soon