Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    2 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.