Change Total in Report

Good day!
I have a question with Total Report , Can you show me how to change it to Total Paid.

Thank you

Show report code.
Adding .sum in expression should total.

This is my code, could you help me to correct it.

[Food Sales by Quantity:2, 1, 1]
{REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum:(ODI=True)&&(MT.Food=Food)}

Assuming you are using unchanged workflow of tickets and orders. Paid status is exclusively Ticket property. Tickets by default have 3 statuses. New, Unpaid and Paid.

Orders have statuses like New, Submitted, Void and Gift.

To get a total of paid items only you will have to query orders from paid tickets.

[Food Sales by Quantity:2, 1, 1]
@{REPORT TICKET DETAILS:T.TicketNumber:(TS.Status=Paid):{0}:,}
{REPORT ORDER DETAILS:O.User,O.ExactTotal.Sum:Ticket.TicketNumber="$1" && (ODI=True) && (MT.Food=Food)}
1 Like

Thank you so much bong

1 Like

Hello Bong,
I dont know why, when I testing , it will show like this.


Can you paste your report code? I think you are missing .sum on O.ExactTotal

O.ExactTotal.Sum Use ready but not work.

OK… I didnt realize (TS.Status=xx) expression works in {REPORT ORDER DETAILS:}

You can find all report tags and expressions here

This should work fine

[Sales by Day:1, 1, 1, 1]
{REPORT ORDER DETAILS:O.User,O.ExactTotal.sum:(TS.Status=Paid) AND (ODI=True) AND (MT.Food=Food)}

Thank so much bong :heart_eyes:

1 Like