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
The Unposted Sales Analysis report includes holds and quotes.
Viewed 1600 times since Mon, Jun 22, 2015
List of available filters for lookups
Viewed 1613 times since Tue, Jul 1, 2014
How to Disable the HTML Focus in Touchscreen Ticket Entry to Prevent Losing Scans or Keystrokes
Viewed 558 times since Fri, Feb 28, 2020
Does NCR Counterpoint support WIC?
Viewed 1344 times since Mon, Feb 22, 2016
Error: Points cannot be redeemed attempting to use a Loyalty Program Pay Code
Viewed 2668 times since Mon, Aug 24, 2015