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