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.

  • Profile Image
    jzbrontee
    Asked on March 22, 2021 at 12:00 PM
  • Profile Image
    Amin_N
    Answered on March 22, 2021 at 05: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_If 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

  • Profile Image
    jzbrontee
    Answered on March 22, 2021 at 07:44 PM
    I was asking about total amount of all orders..
    ...
  • Profile Image
    gerardw
    Answered on March 23, 2021 at 04: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.png

    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

  • Profile Image
    jzbrontee
    Answered on March 28, 2021 at 01:22 PM
    Thank you very much for the info;);)
    ...