I have some troubles in extracting selected data elements from 4.
The logic would be to extract only the Invoices Type AP and show the charges in the AP invoice where AFC is not present and return a null status for the AP invoices where there is a AFC or even better do not show at all the shipments that at AP invoice level have a AFC Charge Code.
I have attached a xls with the data elements and the expected result. Can anyone try to help me with the expression I should use in the dimension or measure that I will have use to obtain the results I am looking for?
Many thanks in advance.