I have a Field name ALERT with values from 1 to 10, and i want this output
Alert <=2, 'None'
Alert >2 and Alert<=6, 'Normal'
Alert >6 and Alert<=10, 'Urgent'
How can i right this?
i had thought to use several ifs, but doesnt work in the same field or i dont know how to write.
May be this
If(ALERT <= 2, 'None',
If(ALERT <= 6, 'Normal', 'Urgent')) as Flags
Wow so simple, thank you a lot. I didnt know how to put if inside a if (until now)
But now you do
Retrieving data ...