3 Replies Latest reply: Oct 12, 2011 4:19 PM by Stefan Wühl RSS

    Using Count on Dimension 1, need sum of above for Dimension 0

      I have a table that is displayed below. I am calculating each weeks overtime hours and std hours

       

      Std hours formula:

      40*count(empid)

       

      OT formula:

      if(sum(laborhrs)-(40*count(empid))<0 , 0 , sum(laborhrs)-(40*count(empid)))

       

      emp count column:

      if(Dimensionality()=0, count(all empid),count(empid))

       

      My issue that I am running into is the total. I need to see the sum of the values. the issue is that the portion count(empid) is returning the wrong number (Should show 446).

      How do I tell this to take the sum of the above for the total?

       

       

       

       

      week                                        std                                 OT                           emp count

      8/29/2011 3280.00 0.00 82
      9/5/2011 3440.00 0.00 86
      9/12/2011 3440.00 760.74 86
      9/19/2011 3840.00 960.90 96
      9/26/2011 3840.00 94.58 96
      Total 4120.00 0.00 261