I'm having trouble with the Lookup function in my ETBMA training project. I've not been able to make one single Lookup function without TBM Studio studio stating it as an error. Now, I'm quite confident that I'm doing it right, hence I'm thinking that there is existing some kind of error.
The task right now is to add the necessary formulas to the Actuals and Budget tables. After my point of view, these would problably be somewhat like this:
- Cost Center, Cost pool, Cost Sub Pool, Fixed Variable, Is Depr, Is Labor, Is Project, Is Vendor, others?
- Cost Center, Cost Pool, Cost Sub Pool, Fixed Variable, Is Depr, Is Labor, Is Vendor
I've tried using both the account and the cost center as matching keys, however, none of them works. I've also tried different 'type overrides' within 'Import', which doesn't do the trick neither.
Could you help troubleshoot?