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..





      Goods Received



      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..



      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?