Announcement

Collapse
No announcement yet.

Totals on "Group by" column are adding up incorrectly?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Totals on "Group by" column are adding up incorrectly?

    Hello,

    Has anyone seen this problem before ? (See Image)

    "Sales Person", "Product", and "Qty Ordered" are coming from the orders table.

    "Customer Price" is coming from the "Products Table" and Total is a calculated field.

    Formula for {total} is........ {total} = {qty_ordered} * {customer_price}

    Thanks works fine but when I turn on totals for the "total" column in SC I get incorrect SUMS as shown in the image attached?

    Anyone know why?


    Sub-Totals-Wrong.jpg
    Last edited by instore; 09-20-2014, 05:32 PM.

  • #2
    hi instore

    can you check the totals configuration, see if the formulas set there is correct, there is avarage, sum, max, min...etc. or perhaps you have some field is calculated... try totalizing one by one and see what happens

    Comment


    • #3
      Take a look at the attached 3 screen grabs.

      I don't get it.

      I get correct totals for all columns except the {totaled} column?

      I have a simple formula to calculate the total.

      Any thoughts on why this is incorrect?
      Attached Files

      Comment


      • #4
        Let's put it this way: It doesn't work correctly on calculated fields.
        Remove your custom field totaled.
        Go to the SQL statement for the grid, add

        qty_ordered * customer_price as totaled

        to the field selection and it'll work.

        jsb
        Last edited by jsbinca; 09-22-2014, 12:38 PM.

        Comment

        Working...
        X