Forum Discussion
Receiving errors when trying to pass and evaluate fields between functions
Hi folks, Hoping someone can help me because I'm stumped (and also kind of a newbie). I have made a custom function, and need to reference it from my main query, passing in each record and a spe...
Hi ImkeF Thank you for your feedback. I tried what you suggested, and although I think it fixed that problem, now I get "Expression.Error: We cannot convert a value of type Table to type Logical." In my function, I am using two nested Table functions, but I don't see how else I can reach my objective of inputting a field (r row and c column), evaluating if it contains the text "(SMT)", and then returning true or false to the custom column, "Flag 2 Test" based on if it finds that text or not. Am I overthinking/over-engineering it?
