Forum Discussion
Wrong total values
Dear Community, have the following table below and receive the wrong column values. hope someone can help to fix that calculation. DATE YEAR = Time Table DATE Month = Time Table DATA 1 = DA...
You have to be careful how you visualize your data. Yoiu are showing me data from two different years and expecting the final measure (Increase or Decrease from the revious Year) to reflect ONLY the current year. Not so! It is aggregating the two years together. Once you have the two number for the DIVIDE function and know they are calculating correctly, then slice or filter your visual by Year. Try this: Add the Year componenet into the Rows portion of the Matrix and I bet for 2023 is should be close.
One other thought: It *may* be considering all of 2022 against 8 months 2023!