How to pull in a column full name of ctype_id=10 the main name not the representative the name =10?
I have build a report and trying to pull with if(contact.ctype_id=10). I tried substring but it doesn't work, I guess I didn't make the correct combination of columns from the tables, but if the ctype_id=10, why is not getting the name that ==10? Not sure what else I can do?
Currently I have this in the column but is not working? It pulls only No Value while there are names
if(contacts.ctype_id =incidents.i_id,if(contacts.ctype_id = 10, contacts.full_name))
Version (include the version you are using, if applicable):