Forum Discussion
Gender
Hello !
I need help categorizing different numbers that tell what gender it is.
Ex:
0, woman
1, man
2, woman
3, man
etc
Is there any good way to create a new variable for it?
Hi Anonymous try it
SWITCH( TRUE(), OR([#] = 0, [#] = 2), "woman", OR([#] = 1, [#] = 3), "man", "etc" )Anonymous See also this file, I optimized the measure and gave 2 examples
4 Replies
Hi Anonymous try it
SWITCH( TRUE(), OR([#] = 0, [#] = 2), "woman", OR([#] = 1, [#] = 3), "man", "etc" )Hello again! I don't really know what I'm doing wrong, but it doesn't seem to work, I've tried several different options Gender2 = SWITCH(TRUE(), OR(Data_renter[Gender_number] = 0, Data_renter[Gender_number]=2), "Female", OR(Data_renter[Gender_number] = 4, Data_renter[Gender_number]=6), "Female", OR(Data_renter[Gender_number] = 8, Data_renter[Gender_number]=10), "Female", OR(Data_renter[Gender_number] = 1, Data_renter[Gender_number]=3), "Male", OR(Data_tenant[Gender_number] = 5, Data_tenant[Gender_number]=7), "Male", OR(Data_renter[Gender_number] = 9, Data_renter[Gender_number]=11), "Male")What am I doing wrong ?