Sum if

[Anonymous]

Hi all,

i have a question and need your help.

I have a list box:

Field 1	Sums (=sum-function)
Munich	122
Augsburg	2344
Köln	234242

Now I would like to show only Munich.

Is this possible in the properties og the listbox

or

can i solve it with a textbox like: =sum(Analysen) if Field1 = Munich

Thank you for helping!

[sunny_talwar · Accepted solution]

May be this

=Sum({<Field1 = {'Munich'}>}Analysen)

[CathyRDuvall]

If you want to maintain using the 'if statement' you would write it as:

sum(if(Field1 = 'Munich', Analysen)