8 Replies Latest reply: Oct 23, 2014 2:41 PM by Gysbert Wassenaar RSS

    Set Analysis with Expression Variable

      Hi All,

       

      I would like to select values to display in a chart based on an expression variable. For example:

       

      Count({$<eAvailability={">=$(=40)"}>} DISTINCT ResourceId)

       

      Where eAvailability = sum of hours available over the next 2 weeks

       

      eAvailability | Sum({$<WeeksAgo={'>=$(=-2)<=$(=0)'}>} AvailableHours)

       

      Based on what I'm reading, I don't think this is possible, but is there another way to get the same result?

       

      Count( {$ <ResourceId= { "=Sum({$<WeeksAgo={'>=$(=-2)<=$(=0)'}>} AvailableHours)>=40 " } DISTINCT ResourceId)

       

      OR

       

      Count({$ <ResourceId= P({1<Sum({$<WeeksAgo={'>=$(=-2)<=$(=0)'}>}AvailableHours)= {">=$(=40)"}>}ResourceId)>} DISTINCT ResourceId)

       

      Thanks in advance!