0 Replies Latest reply on Sep 20, 2011 9:23 AM by joaol

    Calculate total from Portal Subtotal....

    joaol

      Title

      Calculate total from Portal Subtotal....

      Post

      Here the my Potral Example

      First:

      Gas Station:A001     Date:28/08/2011

                        CarID            Liter(L)

                         001                20

                         002                20

                         003                10

                         001                10

      _________________________________________

          Total Car: 4     Total Liter: 60

       

       

      Second

      Gas Station:A002     Date:29/08/2011

                        CarID            Liter(L)

                         001                20

                         004                40

                         005                30

                         002                20

      _________________________________________

          Total Car: 4     Total Liter: 110

       

       

      Total Car = Count (CarID)        Total Liter = Sum (Liter)

       

      If I want to get the total cars and total liter of ( Fisrt + Second)

      mean total Cars= 4+4=8   total liter= 60+110= 170

      how can I  make it work,,,,thank you