Forum Discussion
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 ...
Anonymous
Try:
Forecsat = SUMX(Append1, SUM(Append1(Actual) + SUM(Append1(Forecast Remaing))
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
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?