I just want to follow up regarding my question above.
Can you please help me.
Make a number (global) field in dashboard having value 0, then use it relation < other tables, so Count(...) counts only positive numbers.
Thank you. I tried your suggestion but my dashboard alerts are not changing. This is what I did, please correct me if I'm wrong.
I created a field on my Dashboard I called it Global Number with a value of zero (0) which I use to connect to my TO Expiring Next Month.
This is the relationship
Dashboard::Global Number < Expiring Next Month::Material Expiring_NextMonth
Sorry I wasn't clear. You need "Add" to the relations, then
Material Expire Retest Next Month = Material Expiring_NextMonth
AND g < Material Balance