Format Report Conditionally

Hi Team,

I’ve created a simple report below:
[Sales by Payment Type:20,15,15,15]

Ticket No|Time|Cash
{REPORT TICKET DETAILS:T.TicketNumber,T.Time,PA.Cash:(TS.Status=Paid)}

I tried:

But it shows All transaction, is there a way to just show the Cash transactions?

Try this:

{REPORT TICKET DETAILS:T.TicketNumber,T.Time,PA.Cash:(TS.Status=Paid) && (PA=Cash)}

1 Like

Awesome that sorted it, cheers.

I missed it by, ‘&&’, that much. Lol

Edit…and the >0 :nerd_face:

1 Like