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]))