Bewerken: CostCenter

Sectie: Computed columns

Reden:

## Computed columns

- `CcrBudRemainAY` — `(CONVERT([decimal](21,5),[CcrBudgetAY]-[CcrCostAY]))`
- `CcrBudRemainBY` — `(CONVERT([decimal](21,5),[CcrBudgetBY]-[CcrCostBY]))`
- `CcrBudRemainLY` — `(CONVERT([decimal](21,5),[CcrBudgetLY]-[CcrCostLY]))`
- `CcrBudRemainNY` — `(CONVERT([decimal](21,5),[CcrBudgetNY]-[CcrCostNY]))`
- `CcrTotBudgetAY` — `(CONVERT([decimal](21,5),[CcrChildBudgetAY]+[CcrBudgetAY]))`
- `CcrTotBudgetBY` — `(CONVERT([decimal](21,5),[CcrSumChldBudgetBY]+[CcrBudgetBY]))`
- `CcrTotBudgetLY` — `(CONVERT([decimal](21,5),[CcrSumChldBudgetLY]+[CcrBudgetLY]))`
- `CcrTotBudgetNY` — `(CONVERT([decimal](21,5),[CcrSumChldBudgetNY]+[CcrBudgetNY]))`
- `CcrTotBudRemainAY` — `(CONVERT([decimal](21,5),([CcrBudgetAY]-[CcrCostAY])+[CcrChildBudRemainAY]))`
- `CcrTotBudRemainBY` — `(CONVERT([decimal](21,5),(([CcrBudgetBY]-[CcrCostBY])+[CcrSumChldBudgetBY])-[CcrSumChldCostBY]))`
- `CcrTotBudRemainLY` — `(CONVERT([decimal](21,5),(([CcrBudgetLY]-[CcrCostLY])+[CcrSumChldBudgetLY])-[CcrSumChldCostLY]))`
- `CcrTotBudRemainNY` — `(CONVERT([decimal](21,5),(([CcrBudgetNY]-[CcrCostNY])+[CcrSumChldBudgetNY])-[CcrSumChldCostNY]))`
- `CcrTotCostAY` — `(CONVERT([decimal](21,5),[CcrChildCostAY]+[CcrCostAY]))`
- `CcrTotCostBY` — `(CONVERT([decimal](21,5),[CcrSumChldCostBY]+[CcrCostBY]))`
- `CcrTotCostLY` — `(CONVERT([decimal](21,5),[CcrSumChldCostLY]+[CcrCostLY]))`
- `CcrTotCostNY` — `(CONVERT([decimal](21,5),[CcrSumChldCostNY]+[CcrCostNY]))`