Estimate revision data base question

Manage
1

I have a screen where I’m trying to eliminate any companies that have downward revisions. However, when I input: CurQDnRevLastWk=0, while the screen does eliminate the very few companies that have had down revisions, it also eliminate lots of other candidates (which I don’t want to do). I assume those are not part of an “estimate data base”. Would Zerona work? If so, how would I write that? I appreciate any help. Doug

2

Give this a whack;

isNA(CurQDnRevLastWk,0)=0

3

That seems to work! Thank you.