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.

       

      Thanks

      Rob