On this page you will find the specifications regarding the Model: Revenue Recognition and Fact Table: INTERNAL LEDGER MEASURES.
| Attribute | Description (where applicable) |
Aggregation of measures is based on SUM if not explicitly noted.
This section describes the basic measures in the cube. These are either measures defined in the core Information Source, in the model itself or in the ETL process. The columns have the following meaning:
| Measure | Calculated Y/N | Contains Time Intelligence Y/N | Definition/Note (where applicable) | Aggregation Type | Hidden Y/N | Tabular Expression |
| Actual Cost (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[ACTUAL_COSTS]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Actual Cost, ACTUAL, Accounting currency, Internal Ledger. |
| Actual Income (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | [Actual Revenue (Actual) IL] - [Total Cost (Actual) IL] // Income = Actual Revenue - Total Cost |
| Actual Income (Actual) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE([Actual Income (Period Amount Calc) X-Rate IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Actual Income, ACTUAL, X-rate currency, Internal Ledger. |
| Actual Income (Period Amount Calc) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | [Actual Revenue (Period Amount Calc) IL] - [Total Cost (Period Amount Calc) IL] // Income = Actual Revenue (Period Amount Calc) IL - Total Cost (Period Amount Calc) IL |
| Actual Income (Period Amount Calc) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Actual Income (Period Amount Calc) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Income, ACTUAL, X-rate Currency, Internal Ledger. |
| Actual Margin (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Actual Income (Actual) IL], [Actual Revenue (Actual) IL]) // The cumulative margin(%) for reporting periods with available ACTUAL figures. // Margin(%) = Cumulative Actual Income / Cumulative Actual Revenue, ACTUAL, X-rate currency, General Ledger. // NOTE: Actual Income = Actual Revenue - Total Cost // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Actual Margin (Actual) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE(DIVIDE([Actual Income (Actual) X-Rate IL], [Actual Revenue (Actual) X-Rate IL]), FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative margin(%) for reporting periods with available ACTUAL figures. // Margin(%) = Cumulative Actual Income / Cumulative Actual Revenue, ACTUAL, X-rate currency, Internal Ledger. // NOTE: Actual Income = Actual Revenue - Total Cost // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Actual Revenue (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[ACTUAL_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Actual Revenue, ACTUAL, Accounting currency, Internal Ledger. |
| Actual Revenue (Actual) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE([Actual Revenue (Period Amount Calc) X-Rate IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Actual Revenue, ACTUAL, X-rate currency, Internal Ledger. |
| Actual Revenue (Period Amount Calc) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], [Actual Revenue (Actual) IL] - CALCULATE([Actual Revenue (Actual) IL], PREVIOUSMONTH('REPORTING PERIOD'[ID])), BLANK()) // The period amount for each reporting period with available ACTUAL figures. // Amount = Actual Revenue, ACTUAL, Accounting Currency, Internal Ledger. |
| Actual Revenue (Period Amount Calc) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Actual Revenue (Period Amount Calc) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available ACTUAL figures. // Amount = Actual Revenue, ACTUAL, X-rate Currency, Internal Ledger. |
| Adjusted Recognized Cost (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[ADJUSTED_RECOG_COST]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Adjusted Recognized Cost, ACTUAL, Accounting currency, Internal Ledger. |
| Adjusted Recognized Revenue (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[ADJUSTED_RECOG_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Adjusted Revenue, ACTUAL, Accounting currency, Internal Ledger. |
| Calculated Cost (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[CALCULATED_COSTS]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Calculated Cost, ACTUAL, Accounting currency, Internal Ledger. |
| Calculated Revenue (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[CALCULATED_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Calculated Revenue, ACTUAL, Accounting currency, Internal Ledger. |
| Completed Cost (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[COMPLETED_COST]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Completed Cost, ACTUAL, Accounting currency, Internal Ledger. |
| Completed Revenue (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[COMPLETED_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Completed Revenue, ACTUAL, Accounting currency, Internal Ledger. |
| Cumulative Recog Cost (Actual) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum IL], CALCULATE([Recog Cost (Actual) IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Recognized Cost, ACTUAL, Accounting currency, Internal Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Cumulative Recog Cost (Actual) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum IL], CALCULATE([Recog Cost (Actual) X-Rate IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Recognized Cost, ACTUAL, X-rate currency, Internal Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Cumulative Recog Cost (Forecast) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE([Recog Cost (Actual) IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] && 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )) + CALCULATE([Recog Cost (Forecast) IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative amount. ACTUAL figures up to the selected Cut-Off Period, followed by including FORECAST figures beyond the selected Cut-Off Period. // Amount = Cumulative Recognized Cost, mix of ACTUAL and FORECAST, Accounting currency, Internal Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Cumulative Recog Cost (Forecast) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE([Recog Cost (Actual) X-Rate IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] && 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )) + CALCULATE([Recog Cost (Forecast) X-Rate IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative amount. ACTUAL figures up to the selected Cut-Off Period, followed by including FORECAST figures beyond the selected Cut-Off Period. // Amount = Cumulative Recognized Cost, mix of ACTUAL and FORECAST, X-rate currency, Internal Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Cumulative Recog Income (Actual) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum IL], CALCULATE([Recog Income (Actual) IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Recognized Income, ACTUAL, Accounting currency, Internal Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available actual amounts. |
| Cumulative Recog Income (Actual) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum IL], CALCULATE([Recog Income (Actual) X-Rate IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Recognized Income, ACTUAL, X-rate currency, Internal Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available actual amounts. |
| Cumulative Recog Income (Forecast) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE([Recog Income (Actual) IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] && 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )) + CALCULATE([Recog Income (Forecast) IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative amount. ACTUAL figures up to the selected Cut-Off Period, followed by including FORECAST figures beyond the selected Cut-Off Period. // Amount = Cumulative Recognized Income, mix of ACTUAL and FORECAST, Accounting currency, Internal Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Cumulative Recog Income (Forecast) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE([Recog Income (Actual) X-Rate IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] && 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )) + CALCULATE([Recog Income (Forecast) X-Rate IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative amount. ACTUAL figures up to the selected Cut-Off Period, followed by including FORECAST figures beyond the selected Cut-Off Period. // Amount = Cumulative Recognized Income, mix of ACTUAL and FORECAST, X-rate currency, Internal Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Cumulative Recog Margin (Actual) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum IL], CALCULATE(DIVIDE([Cumulative Recog Income (Actual) IL], [Cumulative Recog Revenue (Actual) IL]), FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative margin(%) for reporting periods with available ACTUAL figures. // Margin(%) = Cumulative Recognized Income / Cumulative Recognized Revenue, ACTUAL, Accounting currency, Internal Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Cumulative Recog Margin (Actual) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum IL], CALCULATE(DIVIDE([Cumulative Recog Income (Actual) X-Rate IL], [Cumulative Recog Revenue (Actual) X-Rate IL]), FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative margin(%) for reporting periods with available ACTUAL figures. // Margin(%) = Cumulative Recognized Income / Cumulative Recognized Revenue, ACTUAL, X-rate currency, Internal Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Cumulative Recog Margin (Forecast) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE(DIVIDE([Cumulative Recog Income (Forecast) IL], [Cumulative Recog Revenue (Forecast) IL]), FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative margin(%). Only ACTUAL figures up to the selected Cut-Off Period, followed by using FORECAST figures beyond the selected Cut-Off Period. // Margin(%) = Cumulative Recognized Income / Cumulative Recognized Revenue, mix of ACTUAL and FORECAST, Accounting currency, Internal Ledger. |
| Cumulative Recog Margin (Forecast) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE(DIVIDE([Cumulative Recog Income (Forecast) X-Rate IL], [Cumulative Recog Revenue (Forecast) X-Rate IL]), FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative margin(%). Only ACTUAL figures up to the selected Cut-Off Period, followed by using FORECAST figures beyond the selected Cut-Off Period. // Margin(%) = Cumulative Recognized Income / Cumulative Recognized Revenue, mix of ACTUAL and FORECAST, X-rate currency, Internal Ledger. |
| Cumulative Recog Revenue (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum IL], CALCULATE([Recog Revenue (Actual) IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Recognized Revenue, ACTUAL, Accounting currency, Internal Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Cumulative Recog Revenue (Actual) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum IL], CALCULATE([Recog Revenue (Actual) X-Rate IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Recognized Revenue, ACTUAL, X-rate currency, Internal Ledger. // The use of the [MaxActualsPeriodNum ..] measure is for securing values only to be presented to the last date with available ACTUAL amounts. |
| Cumulative Recog Revenue (Forecast) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE([Recog Revenue (Actual) IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] && 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )) + CALCULATE([Recog Revenue (Forecast) IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative amount. ACTUAL figures up to the selected Cut-Off Period, followed by including FORECAST figures beyond the selected Cut-Off Period. // Amount = Cumulative Recognized Revenue, mix of ACTUAL and FORECAST, Accounting currency, Internal Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Cumulative Recog Revenue (Forecast) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR MaxDate = MAX('REPORTING PERIOD'[ID]) RETURN CALCULATE([Recog Revenue (Actual) X-Rate IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] && 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )) + CALCULATE([Recog Revenue (Forecast) X-Rate IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MaxDate )) // The cumulative amount. ACTUAL figures up to the selected Cut-Off Period, followed by including FORECAST figures beyond the selected Cut-Off Period. // Amount = Cumulative Recognized Revenue, mix of ACTUAL and FORECAST, X-rate currency, Internal Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Diff Cumulative Recog Cost (Act vs Fc) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Cost (Actual) IL]) || ISBLANK([Recog Cost (Forecast) IL]), BLANK(), [Cumulative Recog Cost (Actual) IL] - [Cumulative Recog Cost (Forecast) IL] ) ) // The difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Cost, ACTUAL minus FORECAST, Accounting currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Cumulative Recog Cost (Act vs Fc) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Cost (Actual) IL]) || ISBLANK([Recog Cost (Forecast) IL]), BLANK(), [Cumulative Recog Cost (Actual) X-Rate IL] - [Cumulative Recog Cost (Forecast) X-Rate IL] ) ) // The difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Cost, ACTUAL minus FORECAST, X-rate currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Cumulative Recog Income (Act vs Fc) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Income (Actual) IL]) || ISBLANK([Recog Income (Forecast) IL]), BLANK(), [Cumulative Recog Income (Actual) IL] - [Cumulative Recog Income (Forecast) IL] ) ) // The difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Income, ACTUAL minus FORECAST, Accounting currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Cumulative Recog Income (Act vs Fc) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Income (Actual) IL]) || ISBLANK([Recog Income (Forecast) IL]), BLANK(), [Cumulative Recog Income (Actual) X-Rate IL] - [Cumulative Recog Income (Forecast) X-Rate IL] ) ) // The difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Income, ACTUAL minus FORECAST, X-rate currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Cumulative Recog Revenue (Act vs Fc) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Revenue (Actual) IL]) || ISBLANK([Recog Revenue (Forecast) IL]), BLANK(), [Cumulative Recog Revenue (Actual) IL] - [Cumulative Recog Revenue (Forecast) IL] ) ) // The difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Revenue, ACTUAL minus FORECAST, Accounting currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Cumulative Recog Revenue (Act vs Fc) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Revenue (Actual) IL]) || ISBLANK([Recog Revenue (Forecast) IL]), BLANK(), [Cumulative Recog Revenue (Actual) X-Rate IL] - [Cumulative Recog Revenue (Forecast) X-Rate IL] ) ) // The difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Revenue, ACTUAL minus FORECAST, X-rate currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Recog Cost (Act vs Fc) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Cost (Actual) IL]) || ISBLANK([Recog Cost (Forecast) IL]), BLANK(), [Recog Cost (Actual) IL] - [Recog Cost (Forecast) IL] ) ) // The difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Cost, ACTUAL minus FORECAST, Accounting currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Recog Cost (Act vs Fc) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Cost (Actual) IL]) || ISBLANK([Recog Cost (Forecast) IL]), BLANK(), [Recog Cost (Actual) X-Rate IL] - [Recog Cost (Forecast) X-Rate IL] ) ) // The difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Cost, ACTUAL minus FORECAST, X-rate currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Recog Income (Act vs Fc) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Income (Actual) IL]) || ISBLANK([Recog Income (Forecast) IL]), BLANK(), [Recog Income (Actual) IL] - [Recog Income (Forecast) IL] ) ) // The difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Income, ACTUAL minus FORECAST, Accounting currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Recog Income (Act vs Fc) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Income (Actual) IL]) || ISBLANK([Recog Income (Forecast) IL]), BLANK(), [Recog Income (Actual) X-Rate IL] - [Recog Income (Forecast) X-Rate IL] ) ) // The difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Income, ACTUAL minus FORECAST, X-rate currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Recog Revenue (Act vs Fc) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Revenue (Actual) IL]) || ISBLANK([Recog Revenue (Forecast) IL]), BLANK(), [Recog Revenue (Actual) IL] - [Recog Revenue (Forecast) IL] ) ) // The difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Revenue, ACTUAL minus FORECAST, Accounting currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff Recog Revenue (Act vs Fc) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('REPORTING PERIOD'[Reporting Year Period Txt]), IF( ISBLANK([Recog Revenue (Actual) IL]) || ISBLANK([Recog Revenue (Forecast) IL]), BLANK(), [Recog Revenue (Actual) X-Rate IL] - [Recog Revenue (Forecast) X-Rate IL] ) ) // The difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Revenue, ACTUAL minus FORECAST, Accounting currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Cumulative Recog Cost (Act vs Fc) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Diff Cumulative Recog Cost (Act vs Fc) IL],ABS([Cumulative Recog Cost (Forecast) IL]), Blank()) // The %-difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Cost, ACTUAL vs FORECAST, Accounting currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Cumulative Recog Cost (Act vs Fc) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Diff Cumulative Recog Cost (Act vs Fc) X-Rate IL],ABS([Cumulative Recog Cost (Forecast) X-Rate IL]), Blank()) // The %-difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Cost, ACTUAL vs FORECAST, X-rate currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Cumulative Recog Income (Act vs Fc) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Diff Cumulative Recog Income (Act vs Fc) IL],ABS([Cumulative Recog Income (Forecast) IL]), Blank()) // The %-difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Income, ACTUAL vs FORECAST, Accounting currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Cumulative Recog Income (Act vs Fc) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Diff Cumulative Recog Income (Act vs Fc) X-Rate IL],ABS([Cumulative Recog Income (Forecast) X-Rate IL]), Blank()) // The %-difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Income, ACTUAL vs FORECAST, X-rate currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Cumulative Recog Revenue (Act vs Fc) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Diff Cumulative Recog Revenue (Act vs Fc) IL],ABS([Cumulative Recog Revenue (Forecast) IL]), Blank()) // The %-difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Revenue, ACTUAL vs FORECAST, Accounting currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Cumulative Recog Revenue (Act vs Fc) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Diff Cumulative Recog Revenue (Act vs Fc) X-Rate IL],ABS([Cumulative Recog Revenue (Forecast) X-Rate IL]), Blank()) // The %-difference between Cumulative ACTUAL amount minus Cumulative FORECAST amount. // Amount = Cumulative Recognized Revenue, ACTUAL vs FORECAST, X-rate currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Recog Cost (Act vs Fc) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Diff Recog Cost (Act vs Fc) IL],ABS([Recog Cost (Forecast) IL]), Blank()) // The %-difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Cost, ACTUAL minus FORECAST, Accounting currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Recog Cost (Act vs Fc) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Diff Recog Cost (Act vs Fc) X-Rate IL],ABS([Recog Cost (Forecast) X-Rate IL]), Blank()) // The %-difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Cost, ACTUAL minus FORECAST, X-rate currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Recog Income (Act vs Fc) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Diff Recog Income (Act vs Fc) IL],ABS([Recog Income (Forecast) IL]), Blank()) // The %-difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Income, ACTUAL minus FORECAST, Accounting currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Recog Income (Act vs Fc) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Diff Recog Income (Act vs Fc) X-Rate IL],ABS([Recog Income (Forecast) X-Rate IL]), Blank()) // The %-difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Income, ACTUAL minus FORECAST, X-rate currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Recog Revenue (Act vs Fc) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Diff Recog Revenue (Act vs Fc) IL],ABS([Recog Revenue (Forecast) IL]), Blank()) // The %-difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Revenue, ACTUAL minus FORECAST, Accounting currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Diff(%) Recog Revenue (Act vs Fc) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Diff Recog Revenue (Act vs Fc) X-Rate IL],ABS([Recog Revenue (Forecast) X-Rate IL]), Blank()) // The %-difference between ACTUAL amount minus FORECAST amount in each period. // Amount = Recognized Revenue, ACTUAL minus FORECAST, X-rate currency, Internal Ledger. // NOTE: This measure is only calculated for reporting periods with both ACTUAL and FORECAST values. |
| Estimated Cost (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[EST_COSTS]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Estimated Cost, ACTUAL, Accounting currency, Internal Ledger. |
| Estimated Cost (Actual) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Cost (Actual) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Estimated Cost, ACTUAL, X-rate currency, Internal Ledger. |
| Estimated Cost (Forecast) IL | Y | N | Cumulative Estimated Cost, ACTUAL or FORECAST, Accounting currency, Internal Ledger. | SUM | N | IF( SELECTEDVALUE('REPORTING PERIOD'[Reporting Year Period]) <= [SelectedCutOffPeriod], [Estimated Cost (Actual) IL], CALCULATE( SUM('FACT FORECAST AMOUNTS'[ESTIMATED_COST]), FILTER( 'FORECAST VERSION', 'FORECAST VERSION'[Ledger ID] <> "00" ) ) ) // The cumulative Estimated cost (Forecast). // ESTIMATED COST(Actual) up to the selected Cut-Off Period, followed by ESTIMATED COST(Forecast) figures beyond the selected Cut-Off Period. // Amount = Cumulative Estimated Cost, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. |
| Estimated Cost (Forecast) X-Rate IL | Y | N | Cumulative Estimated Cost, ACTUAL or FORECAST, X-rate currency, Internal Ledger. | SUM | N | VAR ActualAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Cost (Actual) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR ForecastAmount = ADDCOLUMNS( SUMMARIZE('FACT FORECAST AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Cost (Forecast) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR ResultActual = SUMX(ActualAmount, [@GLAmount] * [@XRates]) VAR ResultForecast = SUMX(ForecastAmount, [@GLAmount] * [@XRates]) RETURN IF( SELECTEDVALUE('REPORTING PERIOD'[Reporting Year Period]) <= [SelectedCutOffPeriod], ResultActual, ResultForecast) // Amount = Cumulative Estimated Cost, ACTUAL and FORECAST, X-rate currency, Internal Ledger. |
| Estimated Income (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[EST_INCOME]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Estimated Income, ACTUAL, Accounting currency, Internal Ledger. |
| Estimated Income (Actual) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Income (Actual) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Estimated Income, ACTUAL, X-rate currency, Internal Ledger. |
| Estimated Income (Forecast) IL | Y | N | Cumulative Estimated Income, ACTUAL or FORECAST, Accounting currency, Internal Ledger. | SUM | N | [Estimated Revenue (Forecast) IL] - [Estimated Cost (Forecast) IL] |
| Estimated Income (Forecast) X-Rate IL | Y | N | Cumulative Estimated Income, ACTUAL or FORECAST, X-rate currency, Internal Ledger. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Income (Forecast) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // Amount = Cumulative Estimated Income, ACTUAL and FORECAST, X-rate currency, Internal Ledger. |
| Estimated Margin (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Estimated Income (Actual) IL], [Estimated Revenue (Actual) IL]) // Cumulative Estimated Margin, ACTUAL, Accounting currency, Internal Ledger. // Estimated Margin(%) calculated as Estimated Income / Estimated Revenue. |
| Estimated Margin (Actual) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Estimated Income (Actual) X-Rate IL], [Estimated Revenue (Actual) X-Rate IL]) // Cumulative Estimated Margin, ACTUAL, X-rate currency, Internal Ledger. // Estimated Margin(%) calculated as Estimated Income / Estimated Revenue. |
| Estimated Margin (Forecast) IL | Y | N | Cumulative Estimated Margin, ACTUAL or FORECAST, Accounting currency, Internal Ledger. | SUM | N | DIVIDE([Estimated Income (Forecast) IL], [Estimated Revenue (Forecast) IL]) // Cumulative Estimated Margin, ACTUAL or FORECAST, Accounting currency, Internal Ledger. // Estimated Margin(%) calculated as Estimated Income (Forecast) IL / Estimated Revenue (Forecast) IL. |
| Estimated Margin (Forecast) X-Rate IL | Y | N | Cumulative Estimated Margin, ACTUAL or FORECAST, X-rate currency, Internal Ledger. | SUM | N | DIVIDE([Estimated Income (Forecast) X-Rate IL], [Estimated Revenue (Forecast) X-Rate IL]) // Cumulative Estimated Margin, ACTUAL and FORECAST, X-rate currency, Internal Ledger. // Estimated Margin(%) calculated as Estimated Income / Estimated Revenue. |
| Estimated Revenue (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[EST_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Estimated Revenue, ACTUAL, Accounting currency, Internal Ledger. |
| Estimated Revenue (Actual) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Revenue (Actual) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Estimated Revenue, ACTUAL, X-rate currency, Internal Ledger. |
| Estimated Revenue (Forecast) IL | Y | N | Cumulative Estimated Revenue, ACTUAL or FORECAST, Accounting currency, Internal Ledger. | SUM | N | IF( SELECTEDVALUE('REPORTING PERIOD'[Reporting Year Period]) <= [SelectedCutOffPeriod], [Estimated Revenue (Actual) IL], CALCULATE( SUM('FACT FORECAST AMOUNTS'[ESTIMATED_REVENUE]), FILTER( 'FORECAST VERSION', 'FORECAST VERSION'[Ledger ID] <> "00" ) ) ) // The cumulative Estimated revenue (Forecast). // ESTIMATED COST(Actual) up to the selected Cut-Off Period, followed by ESTIMATED COST(Forecast) figures beyond the selected Cut-Off Period. // Amount = Cumulative Estimated Cost, mix of ACTUAL and FORECAST, Accounting currency, General Ledger. |
| Estimated Revenue (Forecast) X-Rate IL | Y | N | Cumulative Estimated Revenue, ACTUAL or FORECAST, X-rate currency, Internal Ledger. | SUM | N | VAR ActualAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Revenue (Actual) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR ForecastAmount = ADDCOLUMNS( SUMMARIZE('FACT FORECAST AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Estimated Revenue (Forecast) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR ResultActual = SUMX(ActualAmount, [@GLAmount] * [@XRates]) VAR ResultForecast = SUMX(ForecastAmount, [@GLAmount] * [@XRates]) RETURN IF( SELECTEDVALUE('REPORTING PERIOD'[Reporting Year Period]) <= [SelectedCutOffPeriod], ResultActual, ResultForecast) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Estimated Revenue, ACTUAL and FORECAST, X-rate currency, Internal Ledger. |
| Excluded Cost (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[EXCLUDED_COST]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Excluded Cost, ACTUAL, Accounting currency, Internal Ledger. |
| Excluded Revenue (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[EXCLUDED_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Excluded Revenue, ACTUAL, Accounting currency, Internal Ledger. |
| Percentage of Completion (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('ACCOUNTING PROJECT'[Accounting Project Code]), CALCULATE( SUM('FACT ACTUAL AMOUNTS'[POC_CURRENT]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) )/100 , BLANK()) // Cumulative Percentage of completion up until the selected period. // NOTE: This measure can only be presented for a single project, so not possible to sum up %-values for multiple projects. |
| Percentage of Completion (Forecast) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR CutOffPeriod = [SelectedCutOffPeriod] VAR CurrentPeriod = SELECTEDVALUE('REPORTING PERIOD'[Reporting Year Period]) RETURN CALCULATE( [Percentage of Completion (Actual) IL], 'REPORTING PERIOD'[Reporting Year Period] <= CutOffPeriod ) + CALCULATE( [Percentage of Completion (Period) (Forecast) IL], ALL('REPORTING PERIOD'), FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) ) ) + IF( CurrentPeriod > CutOffPeriod, CALCULATE( [Percentage of Completion (Actual) IL], ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[Reporting Year Period] = CutOffPeriod ), BLANK() ) // Cumulative Percentage of Completion IL calculated as PoC (Actual) IL until cut off period thereafter adding cumulative PoC (Forecast) IL value in each period. |
| Percentage of Completion (Period) (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum IL], [Percentage of Completion (Actual) IL] - CALCULATE([Percentage of Completion (Actual) IL], PREVIOUSMONTH('REPORTING PERIOD'[ID])), BLANK()) // Period value for Percentage of Completion (Actual) IL for each reporting period with available ACTUAL figures. // NOTE: This measure can only be presented for a single project, so not possible to sum up %-values for multiple projects. |
| Percentage of Completion (Period) (Forecast) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(HASONEVALUE('ACCOUNTING PROJECT'[Accounting Project Code]), CALCULATE( SUM('FACT FORECAST AMOUNTS'[POC_CURRENT]), FILTER( 'FORECAST VERSION', 'FORECAST VERSION'[Ledger ID] <> "00" ) )/100 , BLANK()) // Period value for Percentage of Completion (Forecast) IL. // NOTE: This measure can only be presented for a single project, so not possible to sum up %-values for multiple projects. |
| Recog Cost (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[COST_RECOG_CURRENT]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Cost, ACTUAL, Accounting Currency, Internal Ledger. |
| Recog Cost (Actual) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Recog Cost (Actual) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Cost, ACTUAL, X-rate Currency, Internal Ledger. |
| Recog Cost (Forecast) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT FORECAST AMOUNTS'[RECOG_COST_PERIOD]), FILTER( 'FORECAST VERSION', 'FORECAST VERSION'[Ledger ID] <> "00" ) ) // The period amount for each reporting period with available FORECAST figures. // Amount = Recognized Cost, FORECAST, Accounting Currency, Internal Ledger. // NOTE: Need to filter on one and only one Cut-Off Period to be able to calculate amount for a single forecast ID. |
| Recog Cost (Forecast) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT FORECAST AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Recog Cost (Forecast) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available FORECAST figures. // Amount = Recognized Cost, FORECAST, X-rate Currency, Internal Ledger. // NOTE: Need to filter on one and only one Cut-Off Period to be able to calculate amount for a single forecast ID. |
| Recog Cost (Mixed) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE([Recog Cost (Actual) IL], FILTER( 'REPORTING PERIOD', 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] )) + [Recog Cost (Forecast) IL] // The period amount for each reporting period with available ACTUAL or FORECAST figures. // ACTUAL figures up to the selected Cut-Off Period, followed by FORECAST figures beyond the selected Cut-Off Period. // Amount = Recognized Cost, ACTUAL or FORECAST, Accounting Currency, Internal Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Recog Cost (Mixed) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE([Recog Cost (Actual) X-Rate IL], FILTER( 'REPORTING PERIOD', 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] )) + [Recog Cost (Forecast) X-Rate IL] // The period amount for each reporting period with available ACTUAL or FORECAST figures. // ACTUAL figures up to the selected Cut-Off Period, followed by FORECAST figures beyond the selected Cut-Off Period. // Amount = Recognized Cost, ACTUAL or FORECAST, X-rate Currency, Internal Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Recog Income (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[INCOME_CURR]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Income, ACTUAL, Accounting Currency, Internal Ledger. |
| Recog Income (Actual) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Recog Income (Actual) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Income, ACTUAL, X-rate Currency, Internal Ledger. |
| Recog Income (Forecast) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | [Recog Revenue (Forecast) IL] - [Recog Cost (Forecast) IL] // The period amount for each reporting period with available FORECAST figures. // Amount = Recognized Income, FORECAST, Accounting Currency, Internal Ledger. // NOTE: Need to filter on one and only one Cut-Off Period to be able to calculate amount for a single forecast ID |
| Recog Income (Forecast) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT FORECAST AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Recog Income (Forecast) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available FORECAST figures. // Amount = Recognized Income, FORECAST, X-rate Currency, Internal Ledger. // NOTE: Need to filter on one and only one Cut-Off Period to be able to calculate amount for a single forecast ID |
| Recog Income (Mixed) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE([Recog Income (Actual) IL], FILTER( 'REPORTING PERIOD', 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] )) + [Recog Income (Forecast) IL] // The period amount for each reporting period with available ACTUAL or FORECAST figures. // ACTUAL figures up to the selected Cut-Off Period, followed by FORECAST figures beyond the selected Cut-Off Period. // Amount = Recognized Income, ACTUAL or FORECAST, Accounting Currency, Internal Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Recog Income (Mixed) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE([Recog Income (Actual) X-Rate IL], FILTER( 'REPORTING PERIOD', 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] )) + [Recog Income (Forecast) X-Rate IL] // The period amount for each reporting period with available ACTUAL or FORECAST figures. // ACTUAL figures up to the selected Cut-Off Period, followed by FORECAST figures beyond the selected Cut-Off Period. // Amount = Recognized Income, ACTUAL or FORECAST, X-rate Currency, Internal Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Recog Margin (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Recog Income (Actual) IL], [Recog Revenue (Actual) IL]) // The period margin(%) for each reporting period with available ACTUAL figures. // Margin(%) = Recognized Income / Recognized Revenue, ACTUAL, Accounting Currency, Internal Ledger. |
| Recog Margin (Actual) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Recog Income (Actual) X-Rate IL], [Recog Revenue (Actual) X-Rate IL]) // The period margin(%) for each reporting period with available ACTUAL figures. // Margin(%) = Recognized Income / Recognized Revenue, ACTUAL, X-rate Currency, Internal Ledger. |
| Recog Margin (Forecast) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Recog Income (Forecast) IL], [Recog Revenue (Forecast) IL]) // The period margin(%) for each reporting period with available FORECAST figures. // Margin(%) = Recognized Income / Recognized Revenue, FORECAST, Accounting Currency, Internal Ledger. |
| Recog Margin (Forecast) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Recog Income (Forecast) X-Rate IL], [Recog Revenue (Forecast) X-Rate IL]) // The period margin(%) for each reporting period with available FORECAST figures. // Margin(%) = Recognized Income / Recognized Revenue, FORECAST, X-rate Currency, Internal Ledger. |
| Recog Margin (Mixed) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Recog Income (Mixed) IL], [Recog Revenue (Mixed) IL]) // The margin(%) by reporting period. Only ACTUAL figures up to the selected Cut-Off Period, followed by using FORECAST figures beyond the selected Cut-Off Period. // Margin(%) = Recognized Income / Recognized Revenue, mix of ACTUAL and FORECAST, Accounting currency, Internal Ledger. |
| Recog Margin (Mixed) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | DIVIDE | N | DIVIDE([Recog Income (Mixed) X-Rate IL], [Recog Revenue (Mixed) X-Rate IL]) // The margin(%) by reporting period. Only ACTUAL figures up to the selected Cut-Off Period, followed by using FORECAST figures beyond the selected Cut-Off Period. // Margin(%) = Recognized Income / Recognized Revenue, mix of ACTUAL and FORECAST, X-rate currency, Internal Ledger. |
| Recog Revenue (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[REVENUE_RECOG_CURR]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Revenue, ACTUAL, Accounting Currency, Internal Ledger. |
| Recog Revenue (Actual) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Recog Revenue (Actual) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available ACTUAL figures. // Amount = Recognized Revenue, ACTUAL, X-rate Currency, Internal Ledger. |
| Recog Revenue (Forecast) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT FORECAST AMOUNTS'[RECOG_REVENUE_PERIOD]), FILTER( 'FORECAST VERSION', 'FORECAST VERSION'[Ledger ID] <> "00" ) ) // The period amount for each reporting period with available FORECAST figures. // Amount = Recognized Revenue, FORECAST, Accounting Currency, Internal Ledger. // NOTE: Need to filter on one and only one Cut-Off Period to be able to calculate amount for a single forecast ID |
| Recog Revenue (Forecast) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT FORECAST AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Recog Revenue (Forecast) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available FORECAST figures. // Amount = Recognized Revenue, FORECAST, X-rate Currency, Internal Ledger. // NOTE: Need to filter on one and only one Cut-Off Period to be able to calculate amount for a single forecast ID |
| Recog Revenue (Mixed) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE([Recog Revenue (Actual) IL], FILTER( 'REPORTING PERIOD', 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] )) + [Recog Revenue (Forecast) IL] // The period amount for each reporting period with available ACTUAL or FORECAST figures. // ACTUAL figures up to the selected Cut-Off Period, followed by FORECAST figures beyond the selected Cut-Off Period. // Amount = Recognized Revenue, ACTUAL or FORECAST, Accounting Currency, Internal Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Recog Revenue (Mixed) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE([Recog Revenue (Actual) X-Rate IL], FILTER( 'REPORTING PERIOD', 'REPORTING PERIOD'[Reporting Year Period] <= [SelectedCutOffPeriod] )) + [Recog Revenue (Forecast) X-Rate IL] // The period amount for each reporting period with available ACTUAL or FORECAST figures. // ACTUAL figures up to the selected Cut-Off Period, followed by FORECAST figures beyond the selected Cut-Off Period. // Amount = Recognized Revenue, ACTUAL or FORECAST, X-rate Currency, Internal Ledger. // The use of the [SelectedCutOffPeriod] measure is for securing ACTUAL values only up to the Cut-Off Period. |
| Simulated Cost (Forecast) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF( SELECTEDVALUE('REPORTING PERIOD'[Reporting Year Period]) <= [SelectedCutOffPeriod], [Total Cost (Actual) IL], CALCULATE( SUM('FACT FORECAST AMOUNTS'[SIMULATED_COST]), FILTER( 'FORECAST VERSION', 'FORECAST VERSION'[Ledger ID] <> "00" ) )) // The cumulative Total cost and Simulated Cost. // TOTAL COST(Actual) up to the selected Cut-Off Period, followed by SIMULATED COST(Forecast) figures beyond the selected Cut-Off Period. // Amount = Cumulative Total Cost and Simulated Cost, mix of ACTUAL and FORECAST, Accounting currency, Internal Ledger. |
| Total Cost (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[TOTAL_COST]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Total Cost, ACTUAL, Accounting currency, Internal Ledger. |
| Total Cost (Actual) X-Rate IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], CALCULATE([Total Cost (Period Amount Calc) X-Rate IL], FILTER( ALL('REPORTING PERIOD'), 'REPORTING PERIOD'[ID] <= MAX('REPORTING PERIOD'[ID]) )), BLANK()) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Total Cost, ACTUAL, X-rate currency, Internal Ledger. |
| Total Cost (Period Amount Calc) IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | IF(MAX('REPORTING PERIOD'[Reporting Year Period])<=[MaxActualsPeriodNum GL], [Total Cost (Actual) IL] - CALCULATE([Total Cost (Actual) IL], PREVIOUSMONTH('REPORTING PERIOD'[ID])), BLANK()) // The period amount for each reporting period with available ACTUAL figures. // Amount = Total Cost calculated as Total Cost (Current period) - Total Cost(Previous period) |
| Total Cost (Period Amount Calc) X-Rate IL | Y | Y | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | VAR RestatedAmount = ADDCOLUMNS( SUMMARIZE('FACT ACTUAL AMOUNTS' ,'REPORTING PERIOD'[Reporting Year Period],'X-RATE FROM CURRENCY'[From Currency Code]) ,"@GLAmount",CALCULATE([Total Cost (Period Amount Calc) IL]) ,"@XRates" ,CALCULATE(SELECTEDVALUE('X-RATES'[CURRENCYRATE])) ) VAR Result = SUMX(RestatedAmount, [@GLAmount] * [@XRates]) RETURN Result // The period amount for each reporting period with available ACTUAL figures. // Amount = Total Cost, ACTUAL, X-rate Currency, Internal Ledger. |
| Total Revenue (Actual) IL | Y | N | The Internal Ledger version of the corresponding General Ledger measure. | SUM | N | CALCULATE( SUM('FACT ACTUAL AMOUNTS'[TOTAL_REVENUE]), FILTER( 'FACT ACTUAL AMOUNTS', 'FACT ACTUAL AMOUNTS'[Ledger_ID_Key] <> "00" ) ) // The cumulative amount for reporting periods with available ACTUAL figures. // Amount = Cumulative Total Revenue, ACTUAL, Accounting currency, Internal Ledger. |
Time based measures are calculated in the cube with respect to other measures. The table below defines the meaning/definition of the different time measures. These measures need to be used with a specific time dimension hierarchy [REPORTING_DATE].[RepDateMFHy].
| Measure | Meaning |
| YTD |
Aggregated value for current month in current year. E.g.
for period 202010 Ytd represents sum of periods 202000-202010. |
| R12 |
For a given period, the sum all months from one year back up to the
previous month. E.g. Rolling 12 for 202010 is the sum of months 201910
- 202009 |
| PY |
Previous Year The value of the corresponding month one year back. E.g. for month 202010, the value of month 201910. |
| YTD PY |
Year to Date Previous Year Aggregated value for corresponding month one year back. E.g. for month 202010 YTD Previous Year represents sum of months 201901-201910. |
| R12 PY |
Rolling 12 (completed) Months Previous Year For a given month, first going one year back, then taking the sum of all months from one (more) year back up to the previous month. E.g. for month 202010 the sum of month 201810-201909 |
| Avg XXX Ytd | Sum XXX YTD/Count XXX YTD |
| Avg XXX R12 | Sum XXX R12/Count XXX R12 |
| XXX % YTD | Count XXX YTD/Count YYY YTD |
| XXX % R12 | Count XXX R12/Count XXX R12 |
| Model Name |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
Additional information can be found in the online documentation of Information Sources.
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| INTERNAL LEDGER MEASURES | FACT_REVENUE_REC_PROJ_TM, FACT_REV_REC_FORC_LINE_ALL_TM | FACT_REVENUE_REC_PROJ_BI, FACT_REV_REC_FORC_LINE_ALL_BI | FACT_REVENUE_REC_PROJ, FACT_REV_REC_FORC_LINE_ALL | On Line |