Report ticket types Help!

[Refunds:1, 1]

I have two ticket types which have negative amounts Refunds and Payouts
I want to have a separate report for each ticket type

I have tried {REPORT TICKET TYPES:TotalAmount < 0 && (TY=Refund)} & {REPORT TICKET TYPES:TotalAmount < 0 && (TY=Payout)}but its not working.

I also have ‘Quotes’ and ‘Layaways’ which I definitely need separated

[Layaways:1, 1]
{REPORT TICKET TYPES:PreOrder && TotalAmount >= 0  && (TY=Layaway)}

You can try that.

[Refund Tickets:1, 1]
{REPORT TICKET DETAILS:T.TicketNumber,T.TotalAmount:(TY=Refund)}
[Layaways:1, 1]
{REPORT TICKET DETAILS:T.TicketNumber,T.TotalAmount:(TY=Layaway)}

OK I got this working another way

[Layaway:1, 1] Layaway|{REPORT TICKET DETAILS:=[T.TotalAmount]-[T.Tax]:(TY=Layaway)} Tax Total|{REPORT TICKET DETAILS:T.Tax:(TY=Layaway)} GRAND TOTAL|{REPORT TICKET DETAILS:T.TotalAmount:(TY=Layaway)

I thought there would have been an easier way to filter the`REPORT TICKET TYPES because it adds the taxes by default but this works too.

Just curious if there is a field for taxable amount?

This is the correct way to do it. However you’ll need to add .sum (like T.Tax.sum) after field names on Total rows.

Looks like we both posted those at the same time.

I have been reading the Custom Report Tags in detail Tutorial and I’m slowly starting to get my head around it.

Ok perfect that was my next question. I did not see anything about the .sum but im sure I probably missed it. Thanks