Hello Experts,
I have a pending purchase order documents report, nn which each purchase order can have more than one line item and each item can/will have different amounts. The amounts are showing up correctly in data preview but when the data comes to the report the amounts are summing up and all the lines displaying same amount.
Ex: I have Document ID: 123456, which has 3 lines items, amount of each line item is $1500 . webi report populating all the three line items but the amount is populating as 4500 for all the 3 line items.
please see the attached document.
Thanks in advance for you help.