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
Item / Customer numbers are not sorted in proper numeric order
Viewed 1211 times since Tue, Jul 8, 2014
Some AntiVirus applications are known to cause issues
Viewed 1002 times since Mon, Nov 9, 2020
Ticket date is outside allowable range error when posting tickets
Viewed 3000 times since Mon, Jan 7, 2019
List of available filters for lookups
Viewed 1854 times since Tue, Jul 1, 2014
How to Disable the HTML Focus in Touchscreen Ticket Entry to Prevent Losing Scans or Keystrokes
Viewed 814 times since Fri, Feb 28, 2020