# View: KNR_Performer_Run_CheckSums

**View Name:** KNR_Performer_Run_CheckSums
**Table Source:** `Derived from: Prod.Stmt_Db_Sales_Nr_Staging, Royalty_Accounting, Royalty_Accounting.Prod`
**File Path:** `views/KNR_Performer_Run_CheckSums.view.lkml`

## Overview

- **File Size:** 611 bytes
- **Lines of Code:** 34
- **Dimensions:** 2
- **Measures:** 2
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `Batch_ID` | string |
| `Row_Count` | string |

## Measures

| Name | Type |
|------|------|
| `Total_USD` | sum |
| `ABACUS_Total` | sum |

## Derived Table

```sql
sql:

select batch_id,
count(*) row_count,
sum(total_usd) Total_USD,
sum(quantity * unit_price_usd) ABACUS_Total
from royalty_accounting.prod.stmt_db_sales_nr_staging
group by batch_id
;;
```