How Average Ticket is calculated in Item Zoom / Monthly History

Home » Categories » NCR Counterpoint » Point of Sale

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

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
8.5 - OLE error ######## in Ticket Entry/TSTE, or when editing TSTE codes
Viewed 1571 times since Wed, Jun 27, 2018
Item / Customer numbers are not sorted in proper numeric order
Viewed 1069 times since Tue, Jul 8, 2014
Error: Points cannot be redeemed attempting to use a Loyalty Program Pay Code
Viewed 2805 times since Mon, Aug 24, 2015
List of available filters for lookups
Viewed 1693 times since Tue, Jul 1, 2014
What causes cost corrections to be created in Counterpoint?
Viewed 1574 times since Thu, Mar 14, 2019