2 Replies Latest reply on Mar 15, 2014 9:19 AM by philmodjunk

    separation from total amount (cash and credit card)

    HelderSantos_1

      Title

      separation from total amount (cash and credit card)

      Post

      dear
           I'm having a hard time with a table
           Payment (__ Id, Type, Value)
           the Type field (cash or credit card)
           I can show the list of payments per day the total amount. what I would do is the separation of the total cash and total in credit card per day.

        • 1. Re: separation from total amount (cash and credit card)
          SteveMartino

               How are you showing a list of payments?  I would think a simple report in a new layout could do this for you. 

               A slower manual way:

               You could also go into Table view, right click or click down arrow on the heading for Cash or Credit Card.  If they are in a value list, sort by value list, and right click or click down arrow again and select Trainling Sub Totals > Running Count

          • 2. Re: separation from total amount (cash and credit card)
            philmodjunk

                 In a List View layout based on the payment table, you can add a sub summary layout part "when sorted by Type". If you add a non running summary field that computes the total of payment to the sub summary layout part, you will see the sub total for each payment type if you also sort your records by Type. Put the same summary field in the footer, header or a grand summary part and you'll see the grand total.