Forum Discussion
Calculating Net Sales from 2 Different Columns
Hello - I am trying to calculate net sales: Total invoiced amount - amount returned Table 1: contains column "total amount" Table 2: contains column "amount returned" They are related via ...
vanessafvg thanks for the reply. The issue is that net sales for customer or manufacturer are not displaying correctly - which makes me think it's an issue with relationships.
I tried adding measures and calculated columns (using the formula screenshotted below) on both "PostedSalesInvoiceSalesInvLines" and "PostedSalesInvoices". The total amount comes from "PostedSalesInvoiceSalesInvLines" and the amount returned comes from "PostedSalesCreditMemosLines".
Hi,
Share the link from where i can download your PBI file. To void confusion, please remove the tables which are not required. Also, please show the expected result very clearly.