7 Replies Latest reply: Jul 17, 2013 7:15 AM by Vishwaranjan Kumar RSS

    Set Analysis with variable

    Paul Damen

      All,

       

      I have 120 projects, I want to count the number of projects which are within budget. The sum is calculated as follows: Sum(Budget) - sum(Actuals)

       

      I thought to make a set analysis in which a created a variable for the calculation of the difference:

       

      Count({< '$(vProjectResult)' = {'>0'}>} [Project ID])

       

      But whatever I try I can't get the variable to work in that place (I tried all kinds of quotes, brackets etc)

       

      My question is, is this possible to create and if so how?

      And if not what would be the best way for me to do this?

       

      Regards,

      Paul