I am running a query below:
ELECT [Overall Performance 1].[Account Name], [Overall Performance 1].[CountOfVendor Name], [Overall Performance 1].[Total Sales], [Overall Performance 1].PO, [Overall Performance 1].[SumOfUnits - Total Count] AS [Total Count], [Overall Performance 1].[On Time Fill Rate %], [Overall Performance 1].[SumOfOn Time Fill Rate % - Chargeback Amount ($)] AS [Fill Rate], ([Fill Rate]/[Total Count]) AS [Fill Rate Charges per Unit Sold], [Overall Performance 1].[Cancellations %], [Overall Performance 1].[SumOfCancellations - Chargeback Amount ($)] AS Cancellation, ([Cancellation]/[Total Count]) AS [Cancellation charge per unit sold], [Overall Performance 1].[On time %], [Overall Performance 1].[SumOfLate Shipments - Chargeback Amount ($)] AS Lateship, ([Lateship]/[Total Count]) AS [Late Shipment per unit sold], [Overall Performance 1].[LateASN %] AS [Ontime ASN %], [Overall Performance 1].[SumOfLate Notification of Shipment - Chargeback Amount ($)] AS [LateASN Charges], ([LateASN Charges]/[Total Count]) AS [Late Notification charges per unit sold], [Overall Performance 1].[Up To Date Inventory %], [Overall Performance 1].[SumOfInventory Compliance - Chargeback Amount ($)] AS Inventory, ([Inventory]/[Total Count]) AS [Inventory Charges per unit sold], [Overall Performance 1].[Average Order Value ($)], ([SumOfOn Time Fill Rate % - Chargeback Amount ($)]+[SumOfCancellations - Chargeback Amount ($)]+[SumOfLate Shipments - Chargeback Amount ($)]+[SumOfLate Notification of Shipment - Chargeback Amount ($)]+[SumOfInventory Compliance - Chargeback Amount ($)]) AS [TOTAL CHARGEBACK], ([Total Chargeback]/[Total Count]) AS [Total charge per unit sold], ([TOTAL CHARGEBACK]/[Total Sales]) AS [% of Sales]
FROM [Overall Performance 1]
GROUP BY [Overall Performance 1].[Account Name], [Overall Performance 1].[CountOfVendor Name], [Overall Performance 1].[Total Sales], [Overall Performance 1].PO, [Overall Performance 1].[SumOfUnits - Total Count], [Overall Performance 1].[On Time Fill Rate %], [Overall Performance 1].[SumOfOn Time Fill Rate % - Chargeback Amount ($)], [Overall Performance 1].[Cancellations %], [Overall Performance 1].[SumOfCancellations - Chargeback Amount ($)], [Overall Performance 1].[On time %], [Overall Performance 1].[SumOfLate Shipments - Chargeback Amount ($)], [Overall Performance 1].[LateASN %], [Overall Performance 1].[SumOfLate Notification of Shipment - Chargeback Amount ($)], [Overall Performance 1].[Up To Date Inventory %], [Overall Performance 1].[SumOfInventory Compliance - Chargeback Amount ($)], [Overall Performance 1].[Average Order Value ($)];
and I Keep getting an Overflow error.
Please help.
Thank you
Bookmarks