I just recently created a dashboard displaying all of the POs to date grouped by customer. I am bringing in all invoices against each PO release. In my BAQ I have a calculated field for the total PO release cost. There are cases where I have several invoices per PO release. I would like to sum the PO release cost but there is a problem because I get repeating PO releases due to the different invoices against it. Is there a way I could modify the sum function to only sum on a change in PO num, PO line, or PO release?
Any thoughts would be helpful.
Thank you,
Drew
Any thoughts would be helpful.
Thank you,
Drew