topic Re: Assign a filter function to the button in App Development

Assign a filter function to the button

mauricexyz — Thu, 29 Feb 2024 08:01:15 GMT

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

Re: Assign a filter function to the button

Antoine04 — Thu, 29 Feb 2024 08:08:21 GMT

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

Re: Assign a filter function to the button

mauricexyz — Thu, 29 Feb 2024 08:39:02 GMT

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