Calc Average Sale in Custom Report

Version 4 V4 Question
1

Average Sales:|$[=F((TN(’{ACCOUNT TRANSACTION TOTAL:Sale Transaction:Sales}’) / (@@GuestTotal)),’#,#0.00’)]

what could be the alternate for @@GuestTotal

how to get total people?

1 Like
2

are you storing it as ticket tag?

3

yes details as:

[Total Pax Tickets:1,1]
T No|[N]Guest
{REPORT TICKET DETAILS:T.TicketNumber,TT.People:(TT=People)}
Total:|@@GuestTotal