Multiple Iif in a calculated Field of a Dashboard

[Juan_Camilo_Jar]

Hello all! I want to knos if there is a way to hace multiple Iif in an expression of a calculated field. Right now I have this:

Iif([Nombre de la cola] = 'Ingreso Admisiones y Registro' , 'Verificaciones Académicas', '')

But I would like to have more than 2 results, si if it doesn´t match the first option, have an ELSE so I can use another Iif, for example:

Iif([Nombre de la cola] = 'Ingreso Admisiones y Registro' , 'Verificaciones Académicas', Iif ([Nombre de la cola] = 'Validación' , 'Solicitudes', '')

[aboucher · Accepted solution]

Hi @Juan Camilo,

I've created a calculated field similar to yours like this:

Expression Editor accepts this format in my expression.  

Is Expression Editor accepting your expression by making it green and you are able to save it?

What are you getting for results in your report for this calculated field?

Thanks!

~Alan