0 Replies Latest reply: Sep 10, 2018 12:07 AM by Fabrizio Anzolin RSS

    Problem with AGGR function

    Fabrizio Anzolin

      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.

      Fabrizio