2 Replies Latest reply: Mar 29, 2017 1:07 PM by Gabriel Padial RSS

    Percentage of DISTINCT COL1 having SUM(COL2) < COL3

    Gabriel Padial

      Hi, community!

       

      I'm having some throuble finding a solution for this. I have a set of data who shows the effort (hours) appointed untill now (GASTOS) per RAT, and I'm trying to find the percentage of DISTINCT RATs (summing the GASTOS column) that are above the estimated effort (ORCADO). The logic behind this is as follows:

      qlik.png

      Can anyone help me with this?

      Thanks a lot!

      gbpadial.