Currently we have a table with (amongst others) the Quantity Delta. Next to the table there are some variable input fields. In these fields, the user can select the Accepted Delta which works for him/her.
To show only the deviations which are bigger than acceptable, the table is filtered by:
Filter Quantity Delta > Accepted Delta
However, in case no input is provided for the accepted delta, the table runs into error. I’d like to keep the input field empty, in order for the users to know what to enter (the text in light grey). As the filter cannot be combined with a case when statement, I couldn’t manage to solve this so far.
Do you have any advice on how to solve this?