view: KNR_Ownership_Run_CheckSums {
  derived_table: {
    sql:

 select batch_id,
count(*) count,
sum(total_usd) Total_USD,
sum(quantity * unit_price_usd) ABACUS_Total
from ROYALTY_ACCOUNTING.PROD.STMT_DB_SALES_DISTRO_STAGING
group by batch_id
    ;;
  }

  dimension: Batch_ID {
    type:  string
    sql: ${TABLE}.batch_id ;;
  }

  dimension: Row_Count {
    type: string
    sql: ${TABLE}.count ;;
    value_format: "#,##0.00"
 }
  measure: Total_USD {
    type: sum
    sql: ${TABLE}.Total_USD ;;
    value_format: "#,##0.00"
  }
  measure: ABACUS_Total {
    type: sum
    sql: ${TABLE}.ABACUS_Total ;;
    value_format: "#,##0.00"
  }
}