Change Total in Report

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