6 Replies Latest reply on Jul 6, 2016 7:08 PM by Sharon Hickox

    count member id as a negative

    Sharon Hickox

      Hi all

       

      A relatively new user....

       

      I have a simple workbook in which I need to count the number of members who have withdrawn monies over the past FY..

       

      I have negative values for the amount however am unsure how to 'count' the related Mbr ID's - bearing in mind that a member may have withdrawn on more than one occasion to be counted as ONE

       

      I have attached a sample test workbook for any assistance...

       

      Many thanks

       

      Sharon