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: -------------------------------...
I used the case statement as it seemed appropriate for the situation. In other situations, you have to use whatever is more appropriate. it depends on the case at hand.