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)




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


      Thanks in advance!