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




        1 2 Previous Next