How do I get report builder to add up the dollar value of items?>It adds up the items but not the amount of the items.

  • jzbrontee
    Asked on March 22, 2021 at 12:00 PM
  • Amin JotForm Support
    Replied on March 22, 2021 at 5:44 PM

    Hi there,

    Thanks for reaching out to us!

    I've checked your account and I can see that quantity adds up to total price as shown below.

    1616449204 60590eb47f022  Screenshot 10If I, in any way, have misunderstood your concern, we would be so much grateful if you could just further elaborate and provide more information, so that we can better assist you.

    Also, it'd be better to provide us with a screenshot of the issue.

    Relayed guide: How-to-post-screenshots-to-our-support-forum

  • jzbrontee
    Replied on March 22, 2021 at 7:44 PM
    I was asking about total amount of all orders..
    ...
  • Girish JotForm Support
    Replied on March 23, 2021 at 4:12 AM

    As far as I can see the reports builder can only show the total of each item/product selected and not all products:

    1616486836 6059a1b41b436 2303 6 Screenshot 10

    To achieve that it is directly not possible to use the payment field - Purchase order or product list field.

    You will need to add the products outside the payment field using Inventory widgets - one widget for each product.

    Then you can use a Form calculation widget to get the total quantity of products - you can add all inventory widgets into the Form calculation widget to get the total quantity: https://www.jotform.com/help/259-how-to-perform-form-calculation-using-a-widget

  • jzbrontee
    Replied on March 28, 2021 at 1:22 PM
    Thank you very much for the info;);)
    ...