Hey Laszlo!

No problem, I can share the calculation.

There is a function in Paperform for when you are using a Product question - it allows you to return the quantity of a specific SKU ordered. In my case, I have the product question set up with 3 individual SKU’s so that I can give volume discounts on raffle tickets sold ($1 per ticket, but 6 tickets for $5 and 15 tickets for $10), so the three ‘products’ are 1 Ticket, 6 Tickets, and 15 Tickets.

The generic formula for this product function is:

{{ uniqueidcode.quantities.SKU }}

(where uniqueidcode is the 5 digit alphanumeric code that Paperform uses to identify a specific question and SKU is the specific SKU of the product in question)

So this will return the number of units of an individual SKU sold after a form is submitted and a payment is made.

In my case, since I have 3 individual SKU’s, and each SKU represents a different number of tickets (SKU1 = 1, SKU2 = 6, SKU3 = 15), in order to return the total number of tickets sold, it just takes a simple multiplication equation that takes into account how many tickets are represented by each SKU:

( {{ uniqueidcode.quantities.SKU1 }} * 1) + ( {{ uniqueidcode.quantities.SKU2 }} * 6) + ( {{ uniqueidcode.quantities.SKU3 }} * 15)

Hope that makes sense!