Hi there,
I'm trying to get this IF statement to work in the formula tool, basically what I'm looking for is to create a new column based on a department number where it'll calculate a figure based on if one column contains "CUSTOMER" and another column also contains the department number on the same record/line. I'm sure it's something to do with my syntax since it's failing once I type ELSE, but I can't figure it out. Any help is appreciated!
Solved! Go to Solution.
My guess would be that one of your columns Story Points, Active Minutes, Sum_Capex Points by Team, or Sum_Capex Actual, is not being stored as a number! Can you check that first?
I would also check that Peoplesoft Department is being currently stored as a number and not a string!
You are also missing an ending parentheses right before ELSE
Thanks Alex! I knew it had to be a simple fix, now time to get some more caffeine 😅
Happens to the best of us! 😊