Formula Field variable set in if statement
What I'm trying to do is have a variable that is declared in a formula field, and that variable equals one of two fields, depending on an if statement. for example: -------------------------------...
Forum Discussion
I figured it out... what I can do is use the if statement in setting the variable, like what you did with Case:
var Text variable = If([Male/Female] = "Male", "This one is Male","This one is Female")
var Text variable = If([Male/Female] = "Male", "This one is Male","This one is Female")