Skip to content

Query: SubQry Sum Total Replaced To Be Billed by Prin Project Pillar

Type: Select
Has Parameters: Yes
Has Joins: No
Has Subquery: No

Tables Referenced

  • Entrepreneur Company Principal Projects
  • vwPurpleWeaveSumTotalNeedsRepBilledToDatebyPPPCriteria

Columns Selected

  • [Entrepreneur Company Principal Projects].[Principal Project Pillar ID]
  • Sum([Allocated Amount]-[Needs Replacement Billed to Date])

SQL

SELECT [Entrepreneur Company Principal Projects].[Principal Project Pillar ID], Sum([Allocated Amount]-[Needs Replacement Billed to Date]) FROM [vwPurpleWeaveSumTotalNeedsRepBilledToDatebyPPPCriteria], [Entrepreneur Company Principal Projects]