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"

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

     

    I have shared my formula could you please suggest where did i go wrong, itwill help me a lot