Total for and Expression

[#1]

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

[jonathandienst · Accepted solution]

Rob

I cant't see your chart, so I don't know what dimension(s) it used, but you can use something like this outside of your chart:

     Sum(Aggr(If([Area Sqft]<SUM(Seats*AreaPerSeat),0,[Area Sqft]-SUM(Seats*AreaPerSeat)), Dimension1,           Dimension2))

Just replace Dimension1, Dimension2 with the chart dimension (actually any field in your model)

Hope that helps

Jonathan

[#3]

Jonathan, that did it - brilliant!.

Thanks for your help.

Rob