How Average Ticket is calculated in Item Zoom / Monthly History

538 September 11, 2014 1981

Summary:

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