jasonm5545 Member

Thanks. When doing this, all it did was change the default to outlier. The flag is not picking up on both conditions.

Donors is a numeric field, and so is both of the thresholds. For example, this last column should be flaggeed, but is not. Every column is showing normal, and outlier is not even an option in the filter pane.

This is my new sql command. For some reason, it is flagging everything as 'Normal', even with values clearly outside of the range. CASE WHEN Donors < Lower Budget Threshold OR Donors > Upper Budget Threshold THEN 'Outlier' ELSE 'Normal' END

Thanks! It helped solve the error but brought me to a different question. I changed the and to an or, and there is no error, but the outlier flag option does not even show in the filter pane. Any idea why?