10 Replies Latest reply: Sep 12, 2011 10:39 AM by Mark Orchard RSS

    Trying to get TOTAL SALES...

    Chris Hopkins

      Hi, i have a Stock Movement app which i am having trouble displaying TOTAL SALES on.

      In the app the user selects the 'Stock Movement' that they wish to view..

       

      i.e.

      Wastage

      Reductions

      Goods Received

      etc

       

      I am loading in a product sales table and movement table.

      After the user selects a Movement Reason (lets say Wastage for this example), only the sales for the day of the wastage is displayed.

      I want the app to display the TOTAL SALES for the product regardless of any other movement or not.

       

      See example below of the WRONG result..

      waste.JPG

       

      And the result i want to see is 1 line (as its only the top line that has waste against it) but with the total sales of 44, not 7.

       

      Does anyone know how i can achieve this?