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