Calculation in a text box

[alec1982]

Hi guys,

I am trying to do some calculation in a text box.

the expression looks like:

= Sum({1}Sales)/Sum({1}EmployeesCount)

I have used {1} so the list boxes dont effect the calcualtio as i am looking at average.

Now I want to apply one filter all the time as follow:  I want this text box to show the same calculations but for three cities where I have a list box named city

City

Atlanta

NY

DC

Anybody can help..

Thxs

[swuehl · Accepted solution]

Maybe like

= Sum({1<City = {Atlanta,NY,DC}>} Sales) / Sum({1<City = {Atlanta,NY,DC}>} EmployeesCount)

[alec1982]

Thxs so much!