10 Replies Latest reply: May 26, 2011 8:46 AM by Patrick Laredo RSS

    How can I add dimension to expression

      Hi,

       

      I am trying to create counter for a number of projects that have spent value under the budget. I decided to use a Text Object for this.

       

      When I do it as a Table Chart, then I can get the number by Summing up the result (3 in the example).

       

      ProjectBudgetSpentResult (1= under, 0=over)
      1100501
      250600
      3200101
      4150351
      TOTAL5001553

       

      But how can I add it to one expression?

       

      When I use if((Sum(Budget)-Sum(Spent))>0,1,0) in the table it works just fine, but in Text object QV will not know what budgets and spent go together.

      Sum(Budget)-Sum(Spent) will give 345 and I cannot count the projects.

       

       

      Thank you in advance!

       

      Mariliis