Setting an alert Threshold not working

[bbulla]

Hi,

I'm trying to set an alert Threshold on a numeric column in a table that gets updated regularly.  For some reason, it will not let me enter a value of less than 1.  I need to set it to .05.

I can set it to 1.  If I try .99, it just reverts back to 1.

Any ideas on what might be happening??

Thanks

[bbulla · Accepted solution]

OK, I think I have this working now.  So I have to enter it as 0.05.  Just typing .05 will not work.

Thanks!

[bbulla]

Hi,

Yes, I have it set to Decimal with 2 decimal places, but still not working.

When configuring the alert, it will not let me enter a value of less than 1.

[Ahmedx]

you need to change the format and it will already be visible there