Skip to Content

How Average Ticket is calculated in Item Zoom / Monthly History

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

How Average Ticket is calculated in Item Zoom / Monthly History
  • COMMENT