constraining find with variable
I've tried a hundred ways of doing this but nothing works. FMP11/mac Intel>
I have two compound finds: active and ongoing, active and fifteenth(or first). From this found set, I wish to omit any record that already has a specific issue number (which changes every 15 days). I have a current issue calculation that works fine. If I set up finds using the actual current issue number, no problem. I can't set it up to use a global variable already set to the current issue number ($$ci)
Here's a screen shot of what works
How can i make it work with the variable instead of the actual issue number?
Thanks for any help.