I have Database A with a fileglobal variable fgvar (a text value).
I have Database B with fields Invoice, DT, and Balance.
This formula in database A does not work even though I know that there is a record that should match.
superlookup("B",{DT="TI" and Invoice=fgvar},{Balance})
I assume the problem is that the scope of fgvar is the file A. Is there someway to make this formula work? Instead of using just fgvar, I tried constantvalue(“fgvar”) and datavalue(“fgvar”) in place of fgvar. That does not work.
Does anyone know how to solve this problem?
PS I did create a global variable with the same value as the fileglobal and that works. But it seems like that should not be necessary.