Budget Variance model measures
The following table lists the measures used in the Budget Variance data model. For information about adding measures to your data models, see Add a measure table.
| Name | Type | Formula |
|---|---|---|
| Hours Actual | Filtered value | CALCULATE( ACTUAL.Value Actual (Sum), KEEPFILTERS(ACCT.ACCT Type = 'Hours') ) |
| Hours Budget | Filtered value | CALCULATE( BUDGET.Value Budget (Sum), KEEPFILTERS(ACCT.ACCT Type = 'Hours') ) |
| Hrly Rate Actual | Division |
Salaries Actual / Hours Actual |
| Hrly Rate Budget | Division |
Salaries Budget / Hours Budget |
| Hrly Rate Variance | Subtraction |
Hrly Rate Budget - Hrly Rate Actual
|
| Hrly Rate Variance Percent | Division |
Hrly Rate Variance / Hrly Rate Budget |
| KeyStats Actual | Filtered value |
CALCULATE( ACTUAL.Value Actual (Sum), KEEPFILTERS(ACCT.ACCT Type = 'KeyStat')) |
| KeyStats Budget | Filtered value | CALCULATE( BUDGET.Value Budget (Sum), KEEPFILTERS(ACCT.ACCT Type = 'KeyStat') ) |
| Overtime Hours Actual | Filtered value | CALCULATE( ACTUAL.Value Actual (Sum), KEEPFILTERS(ACCT.ACCT FSDetail = 'H_Overtime') ) |
| Overtime Hours Budget | Filtered value | CALCULATE( BUDGET.Value Budget (Sum), KEEPFILTERS(ACCT.ACCT FSDetail = 'H_Overtime') ) |
| Overtime Percent Actual | Division |
Overtime Hours Actual / Hours Actual |
| Overtime Percent Budget | Division |
Overtime Hours Budget / Hours Budget |
| Overtime Percent Variance | Subtraction |
Overtime Percent Budget - Overtime Percent Actual |
| Overtime Percent Variance Percent | Division |
Overtime Percent Variance / Overtime Percent Budget |
| Per Unit Actual | Division |
ACTUAL.Value Actual (Sum) / KeyStats Actual |
| Per Unit Budget | Division |
BUDGET.Value Budget (Sum) / KeyStats Budget |
| Salaries Actual | Filtered value | CALCULATE( ACTUAL.Value Actual (Sum), KEEPFILTERS(ACCT.ACCT FSDetail IN ('E_Salaries', 'E_SalariesContract', 'E_SalariesMid', 'E_SalariesPhy')) ) |
| Salaries Budget | Filtered value | CALCULATE( BUDGET.Value Budget (Sum), KEEPFILTERS(ACCT.ACCT FSDetail IN ('E_Salaries', 'E_SalariesContract', 'E_SalariesMid', 'E_SalariesPhy')) ) |
| Variance Amount | Subtraction |
ACTUAL.Value Actual (Sum) - BUDGET.Value Budget (Sum) |
| Variance Amount 2 | Subtraction |
BUDGET.Value Budget (Sum) - ACTUAL.Value Actual (Sum) |
| Variance Percent | Division |
Variance Amount / BUDGET.Value Budget (Sum) |
| Variance Percent 2 | Division |
Variance Amount 2 / BUDGET.Value Budget (Sum) |
Dimensions included as pivot tables
| Name | Columns |
|---|---|
| ACCT |
ACCT, ACCT Description, FSDetail, FSSSummary, Type |
| DEPT | DEPT, DEPT Description, Director, Division, ENTITY, Entity Description, Manager, VP |
| INITIATIVEID | APPROVE, INITIATIVEID Description |
RPTMAP-compliant ACCT and DEPT fields
In addition to standard ACCT and DEPT dimension fields, you also have access to RPTMAP-compliant versions of these fields, which aggregate and combine values into a single line item within a visualization. These fields ensure the values contained in a report match the values contained inside a visualization.
| Name | Columns |
|---|---|
| ACCT | ACCT RptMap Account code, ACCT RptMap Account description, ACCT RptMap FSDetail, ACCT RptMap FSSummary, ACCT RptMap Type |
| DEPT | DEPT RptMap code, DEPT RptMap Description, DEPT RptMap Entity code, DEPT RptMap Entity Description, DEPT RptMap VP |
Data table columns
| Name | Columns |
|---|---|
| ACTUAL | ACCT, Date, DEPT, INITIATIVEID, Value Actual |
| BUDGET | ACCT, Date, DEPT, INITIATIVEID, Value Budget |
