AnsweredAssumed Answered

Calculate total from Portal Subtotal....

Question asked by joaol on Sep 20, 2011

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

Outcomes