2 Replies Latest reply: Oct 1, 2013 8:53 AM by Celambarasan Adhimulam RSS

    Sum issue


      Good day,

       

      Boss for all workers = Jan

       

      But Jan is also on some of the jobs. I want to split the 'Nr' between Jan and the rest.

       

      The problem is, I need the total for Jan to be 1+1+1+1+1+1+1+1+1+1 = 10

       

      and not

       

      1+1+1+1+1+1+1+1+1+1  * 10  = 100

       

      Is there any way to do that, I cant use Max as some of the 'Nr' s won't be 1

       

      See attached

       

      Please help