Forum Discussion
Switch Statement not working to create a new column
I want to create a new column in my data, based off the value of an existing column. I did not want to use an if statement, because would have to use about 9 nested statements and that is soooooo me...
Maybe try trimming PMO_Time[Project Number], just in case there's a space or something in front/behind it. Maybe it needs to be padded with zeros or something else?
jdobrzen
Advocate III
Advocate IIIMaybe try trimming PMO_Time[Project Number], just in case there's a space or something in front/behind it. Maybe it needs to be padded with zeros or something else?
Thank you. That was it and easy to fix.. once you pointed me in the correct direction.