Forum Discussion
Column Total does not match
Hi, I need your help. I have a Purchase Price Variance report where I needed to show in a table: These items are sourced from the same source table 'me2l' with a date range of 1 Jan 2021 to prese...
Hi all,
We were able to identify the issue. Instead of averaging the Unit Price, we instead get the Average of PO value / Ordered Qty to arrive at the Average unit price. We also used the Round (x).
Thank you to Yangliu for your inputs and suggestions.
Noted and thanks for taking time responding to my inquiry.
Hi all,
I am validating the one in Power BI and the one extracted to Excel. See sample item below:
The one in Power BI report has no value in PPV since the Average Unit Rate in Current Year is the same as the Average Unit Rate in Last Year. However, the one extracted to Excel somehow erroneously generated a difference of (36,119.29).
How is that possible? Could it be that it has something to do with the PPV TOTAL measure?