Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Income Statement Matrix

 

Below I have a picture of a Matrix of an Incomestatement :  For Budget it is totaling correctly; however, I want expenses to be positive.  In actuals I flipped expenses to be positive; however, now the grand total is off.  How can I get it to where I have positive rev - positive exp = total?

 

Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    Anonymous,

     

    Try this solution:

     

    1. Create calculated column:

     

    Adjusted Actuals = IF ( FactTable[Main Type] = "Expenses", [Actuals] * -1, [Actuals] )

     

    2. Create measure:

     

    Actuals = 
IF (
    HASONEVALUE ( FactTable[Main Type] ),
    SUM ( FactTable[Actuals] ),
    SUM ( FactTable[Adjusted Actuals] )
)

     

     

1 Reply

  • DataInsights's avatar
    DataInsights
    Icon for Super User rankSuper User
    4 years ago

    Anonymous,

     

    Try this solution:

     

    1. Create calculated column:

     

    Adjusted Actuals = IF ( FactTable[Main Type] = "Expenses", [Actuals] * -1, [Actuals] )

     

    2. Create measure:

     

    Actuals = 
IF (
    HASONEVALUE ( FactTable[Main Type] ),
    SUM ( FactTable[Actuals] ),
    SUM ( FactTable[Adjusted Actuals] )
)