1 Reply Latest reply: Nov 2, 2012 11:15 AM by Diego Fernando Caivano RSS

    Calculating effort % from an Assignment Matrix

      Back again to ask you a little help...

       

      I have an Assignement Matrix or better a RAM (Responsibility Assignement Matrix) and i would like to calculate the effort for each office (in %).

      Here is kind of example:

       

      ACTIVITIESOFFICE1OFFICE2OFFICE3
      Activity 1XX
      Activity 2X
      Activity 3XX
      Activity 4X

       

       

       

      I would like to see a table like this one:

       

      OFFICEEFFORT
      OFFICE125%
      OFFICE250%
      OFFICE375%

       

      I first realised it in Excel using the COUNT.IF formula to count how many "X" are there for each office and then dividing by the # of total activities (in this case 4).

       

      I actually can't find any count-if or similar in qlikview... could you help me?