Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

If Statement Aggregation

Hi,    I wrote a measure to calculate job costs utilizing different accounting methods based on time intelligence. My example code is below: Estimated Final Cost = VAR CurrentDate = TODAY() VAR...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

You are not showing enough details. The definitions of 

[Field Estimate Amount]
[AFE Amount]
[Adjusted Lateral Length]

may or may not impact your calculations. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

No Problem

 

Accounting Actual =
CALCULATE (
    SUM ( vwSpotfire_CAPEX[SumAmount] ),
    USERELATIONSHIP ( vwSpotfire_CAPEX[CategoryName], 'Expense Classification Bridge'[CategoryName] )
)
AFE Amount =
CALCULATE (
    SUM ( AFE_Budget_All[AFEBudget] ),
    USERELATIONSHIP ( AFE_Budget_All[CategoryName], 'Expense Classification Bridge'[CategoryName] )
)

 

Field Estimate Amount =
CALCULATE (
    SUM ( vwSpotfire_CAPEX_Estimated_Expense[EstimatedExpenses] ),
    USERELATIONSHIP ( vwSpotfire_CAPEX_Estimated_Expense[CategoryName], 'Expense Classification Bridge'[CategoryName] )
)
Adjusted Lateral Length = CALCULATE(SUM('MDM WELL'[Lateral Length]))