i have an value called "aantal" and i want to exclude everything higher then 10.000. how do i do this?
Where do you want to do this? In the front-end or the back-end?
It would help to give us a test application or some test data.
If your 'Aantal' is an actual value in the table you can use:
IF( Aantal > 10000
IF( Aantal < 10000
View solution in original post
if(aantal > 10000,
Explanation: If the "aantal" selected is higher than 10000 will so "-" if is not higher will show the value