Assign a filter function to the button

[mauricexyz]

Hello,

I would like to store a filter per action on a button as described above. To do this, I have selected "Select values that match the search criteria" under Actions for the button. Then the source. Now I have used the following code under Functions:

=sum({<sales statistics.STNBTR = {">50000"}>} sales statistics.STNBTR)

If I now activate the button, I only get all values with 0 in the corresponding column.
What is the problem here?

Thank you very much!
Maurice

[Antoine04]

Hello,

The syntax is incorrect.

What you need to write is something like this : ='>50000'

And of course mentionning your field STNBTR in the parameter of the button.

Regards,

Antoine L

[mauricexyz · Accepted solution]

I now have the solution. It was very simple, as the formula has to be entered as a string. That's probably what you meant. The solution was:

='=Sum(Turnover statistics.STNBTR > 50000)'

Thank you very much!
Maurice