Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be this
=Sum({<Field1 = {'Munich'}>}Analysen)
If you want to maintain using the 'if statement' you would write it as:
sum(if(Field1 = 'Munich', Analysen)