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

Posted - September 5, 2014. This article has been viewed 1496 times.
Online URL: https://counterpoint.knowledgebase.co/article.php?id=538

Powered by PHPKB (Knowledge Base Software)