Forum Discussion
Lookupvalue is blank?
I am trying to get the Lookupvalue function to pull a number from a table. I have three relationships in the table, all are working. Yet when I run the query the amounts are coming up blank? The four...
Hard to tell without seeing exactly the budget table,but is it possible you have multiple rows in the result of the lookup? This will return a blank. Maybe the granularity of your Budget table is higher than state, group and scenario?