Format Report Conditionally

V5 Question
1

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:
DETAILS:T.TicketNumber,T.Time,PA.Cash:(TS.Status=Paid),(PA.Cash>0)}

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

2

Try this:

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

https://kb.sambapos.com/en/9-1-3-custom-reporting-tags/

1 Like
3

Awesome that sorted it, cheers.

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

Edit…and the >0 :nerd_face:

1 Like