How do i exclude a value

[Pierremeesters]

Hi

i have an value called "aantal" and i want to exclude everything higher then 10.000. how do i do this? 

[JordyWegman · Accepted solution]

Hi Pierre,

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
    , null()
    , Aantal
)

Cleaner is:

IF( Aantal < 10000
    , Aantal
)

Jordy
Climber

[rui24]

Hi Pierremeesters

Try this:

if(aantal > 10000,

'-',

Status

)

Explanation: If the "aantal" selected is higher than 10000 will so "-" if is not higher will show the value