Forum Discussion
Anonymous
2 years agoNot applicable
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...
- Anonymous2 years ago
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.
Anonymous
2 years agoNot applicable
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.