**Summary: **

How Average Ticket is calculated in Item Zoom / Monthly History

What data makes up the Average Ticket in the Monthly History item zoom screen?

**Solution: **

The calculation to compute Average Ticket is below. NCR Counterpoint takes the sum of PS_TKT_HIST_LIN.EXT_PRC and divides this by the total number of tickets for the month.

Formula for Average Ticket:

CAST(COALESCE (SUM(PS_TKT_HIST_LIN.EXT_PRC) / NULL IF (SUM(CASE WHEN TKT_NO IS NOT NULL THEN 1 ELSE 0 END), 0), 0) AS decimal(15, 2)) AS Avg_Ticket

Article ID: 538

Created: September 5, 2014

Last Updated: September 11, 2014

Online URL: https://counterpoint.knowledgebase.co/article.php?id=538