Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Matrix Total displaying wrong value for one column

Hi,   I have a matrix report where I have created a measure for values  "Reveue-Expenses", it is working fine for all the columns except the last column, please find the below image for reference  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago
Forecast = (SUM('Append1'[Actual]) + SUM('Append1'[Forecast Remaining]))
This is formula i am using in the report as Expense has negative values.
  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    Anonymous 

    Try:

    Forecsat = SUMX(Append1, SUM(Append1(Actual) + SUM(Append1(Forecast Remaing))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hey Thank you so much for the reply but It did not work it is giving me wrong values, I have used the formula you suggested and created measure "New Forecast"

       

       

      • PaulDBrown's avatar
        PaulDBrown
        Community Champion
        5 years ago

        Anonymous 

        Without seeing how the model is set up and the tables used it is a bit of a guessing game, However, let's try the following. Assuming your period column is from a Period Table[period], try:
        New forecast = SUMX(Period Table, SUM(Append1(Actual) + SUM(Append1(Forecast Remaing))

         

        If that doesn't work, can you show the hierarchy in the matrix, the model and relationships within?