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

    Calculate on row and roll up

    Paul Damen

      All,

       

      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