How do I only show Tickets with TotalAmount greater than zero?

V5 Question
1

Greetings Friends,

I have made a report as follows:

[Sales in Restaurant: 1.1, 1, 2, 1.2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1]
>Day|Time|Invoice No|Food Sales|Total|Service Charges|GST|Percent|Discount|Round +|Round -|Cash|Credit|Zomato
{REPORT TICKET DETAILS:T.Date,T.Time,T.TicketNumber,([T.TotalAmount]-[CA.Discount]-[T.Tax]-[CA.Servicing Charges]-[CA.Auto Round -]+[CA.Auto Round +]),T.TotalAmount,CA.Servicing Charges,T.Tax,CA.Discount,CA.Auto Round +,CA.Auto Round -,PA.Cash,PA.Credit Card,PA.Voucher:(TS.Status=Paid) AND (DE=Restaurant)}
>Total |||{REPORT TICKET DETAILS:([T.TotalAmount]-[CA.Discount]-[T.Tax]-[CA.Servicing Charges]-[CA.Auto Round -]+[CA.Auto Round +]).sum,T.TotalAmount.sum,CA.Servicing Charges.sum,T.Tax.sum,([T.Tax.sum]  * 100 / ([T.TotalAmount.sum]-[T.Tax.sum])),CA.Discount.sum,CA.Auto Round +.sum,CA.Auto Round -.sum,PA.Cash.sum,PA.Credit Card.sum,PA.Voucher.sum:(TS.Status=Paid) AND (DE=Restaurant)}

Some of my tickets have a TotalAmount value of zero. How do I remove them from this report?

I tried adding a constraint as (T.TotalAmount>0) but, it did not work.

Please help.

Regards,

Somil

2

T.TotalAmount is a field selector and as such has different syntax than other constraints. Try this (notice NO brackets around amount):

(TS.Status=Paid) AND (DE=Restaurant) AND T.TotalAmount>0
3

Thanks a lot QMcKay, it works!!!