2 Replies Latest reply: Jul 7, 2012 12:51 PM by Rob Wright RSS

    Total for and Expression

      Hi there, I managed to create an expression that identifies the excess area within a set of buildings.


      I would like to create the total for the buildings that are identified as in excess of the target I have set.


      This is the chart the expression creates


      If([Area Sqft]<SUM(Seats*AreaPerSeat),0,[Area Sqft]-SUM(Seats*AreaPerSeat))



      I would like to create a Text Object that displays the total value of all the excess space identified in the expression.


      Appreciate any support or ideas.