I have a dataset that has parent part, mtlpart, the department (numerical value) of said mtlpart and bom level in columns. I need to select the select the minimum bom level in a specific department. I’m using a case when function with an AND but keep getting an error of non boolean type where a boolean type is expected. How do I do this?
Hello Justin,
Tough to say as I cannot see how your BAQ. I would recommend a possible subquery to execute the min values if your case function is not being accepted.
1 Like