12 Replies Latest reply: Feb 14, 2017 2:09 PM by Maria Harmening RSS

    count aggr sum

    Maria Harmening

      i'd like to aggregate data 2 categories and then sum hours within that aggregation.  then if the sum of the hours is greater than zero, i'd like to count how many there are within the aggregation.  this is the formula i have, but I'm missing something..

       

      count({<{$(aggr(sum([Planned Hours]),[Pva Macro],[Pva Emp Name])={">0"}}>} [Planned Hours])

       

      please do not attach qvf files because I cannot load them on my machine.

       

      Thanks,

      Maria