Need help using LOOKUP or SELECT function
I'm trying to create a line item in the target module that pulls in the values from the source module given a certain day. Attached are screen shots of the modules. Please advise.
What would you expect to see for "SFS Funding" in January 4th for example?0
The reason it is not working is because in your target module there is a dimension called Funding Only and in Source module
you have diff dimension called Loan Type. See what is the relationship between these two dimensions and then use the valid function to move the data from source to target module.
Good catch. Yes Indeed there is LOOKUP missing on that as well. But there is a dimensionality mismatch also.
Thank you for your help. we figured it out.0