9 Replies Latest reply on Mar 29, 2017 4:06 AM by Nagarajan R

    Calculate on row and roll up

    Paul Damen



      I have 2 name fields and I want to match those, then on the overall name I want to display the count number. For example:


      Name1                    Name2

      Paul                         Paul    

      Paul                         Paul

      Paul                         Other

      Jonathan               Jonathan

      Jonathan               Other

      Jonathan               Other


      What I need:

      Name1               Count

      Paul                       2

      Jonathan               1


      I now use this formula: if Name1 = Name2 then 1 end. This works on the lowest level, but as soon as I roll it up it just counts all records and Name1 is the same number as name2


      Hope you can help!


      Regards, Paul