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:


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




      I would like to see a table like this one:




      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?