advanced calculations/ cpq - divide by month the price for each product line item in the pricing table

https://pandadoc.zendesk.com/agent/tickets/417938

Formula option for Tables

Excel formulas being possible within PandaDoc Tables. Specifically, a sum formula and one for percentage increases/decreases would be ideal.

Top 3 Idea from 2 years ago (and a critical one) and still just an idea...

Ability to add formulas to tables in PandaDoc templates

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.

A standard table that mimics excel for building an employee expense report in forms

Improve general management of SKU in the catalogue.
The present catalogue is too basic.
1. Organize SKU/Catalog Items packages into lists/membership lists to offer a complete SKU package. That is to be able to import in a single stroke in a pricing table more SKU that I belong to a package composed from more SKU.
2. insert a function that allows you to edit the data of the SKU of the catalogue directly from Pandadoc without having to export to a CSV file and then having to import them back into the catalogue in Pandadoc. By doing this operation sometimes imports do not work well in converting CSV to Excell and you risk losing data or damaging it. It would be more useful a mass modification function of the articles of the catalog (how to increase all prices by a certain percentage)

a pricing table whereby the user is able to enter a quantity and the rate charged per quantity will automatically update based on quantity selected.

This would definitely help to streamline contracts by allowing the client to choose their price using a calculator.

I would like to see the client choose the service location, the term of the agreement, the number of widgets, other widget options that would change the product SKU, the description, and their monthly/yearly pricing.

I assumed this would be core product. Can you not create basic formulas in pricing tables? That is strange

Yes - Formulas would be a game changer

should be possible to do a field a formula? For example, I want to do a formula that shows the dollar amount of our seasonal discount that is a % of another field.

Would love this feature, as well!

Yes please! Formulas!

Yes! In my propositions, on the last line of a Pricing table I manually subtotalize all upper lines costs, and then apply a production fee multiplying this global subtotal by a %.

But if I authorize options boxes by clients, my production fee line will not be updated.

It would be great to have a bottom line option, offering a formula like : =sum(above.section.subtotals)*[%multiplier.column).

Add simple formula ability in table cells using data from other cells, or referenced cloud based csv files. (+-*/)

Hey all! Some Basic formulas in tables would be great, much like Excel and Google. I know this has been requested for Pricing Tables, but this would also be useful for standard tables.

Example: I would like to calculate a series of dates based on a starting date.
Date 1 + 7 days = Date 2

Dates, Numbers, Time of Day would all be useful

Can have the pricing table compute in different columns just like the way excel does?

Enable the subtotal after a discount is imposed and auto-compute the amount before & after tax