1 2 Previous Next 19 Replies Latest reply on Jun 15, 2018 6:51 AM by Seth Nelson

    Calculation of Unique Count

    chandrakanth k

      Hello All,

       

      In my data source I have two sheets and I have joined two sheets with common field "Cocd_DocNo".

      I have two systems SAP & Dolphin. Only for SAP lines I have values for "Cocd_DocNo" header and would it will null for Dolphin.

       

      I need a get a count of lines which are sheet 1. The total count is 30 in sheet 1 but I am unable to get that count. I was able to combine the amount but not the count.

       

      My desired result from the data source is total amount -196214.07 and count = 30

       

      Need help

       

      Regards,

      Chandrakanth.K

        1 2 Previous Next