Change Total in Report

[1112]

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

Thank you

[JTRTech]

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

[1112]

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)}

[Posflow]

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)}

[1112]

Thank you so much bong

[Meng]

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

[Posflow]

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

[Meng]

O.ExactTotal.Sum Use ready but not work.

[Posflow]

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

You can find all report tags and expressions here

Custom Report Tags in detail

###Expressions We’ll use expressions to filter results returned by tags. If you are familiar with SQL, you can think these as Where sections. For Example… {REPORT PAYMENT TOTAL:} This tag will display total of all payments that created inside reporting period. As it will total of all cash, credit card or other type of payments we’ll need a <expression> for more precise total. For reading a total of only Cash payments the syntax should be… {REPORT PAYMENT TOTAL:(PT=Cash)} ###Syntax (<Field>=…

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)}

[Meng]

Thank so much bong