Hello!
I have a column that has type Int 64. I need to replace all the numbers that are =>5 with a 5+. I keep getting errors or when using an IIF it is replacing all the numbers in that column.
Solved! Go to Solution.
EDIT: I misread the post. Follow @MarqueeCrew's instructions.
Hi Mark!
I am getting Malformed IF Statement with this.
IIF(tostring([Not Processed Days From Received to Today]>5,"5+",[Not Processed Days From Received to Today])
Thanks!
If I assume that your [Not Processed Days From Received to Today] variable is a string, your IIF statement should be:
IIF(ToNumber([Not Processed Days From Received to Today])>5,"5+",[Not Processed Days From Received to Today])
Alternatively:
IF ToNumber([Not Processed Days From Received to Today])>5 THEN "5+" ELSE [Not Processed Days From Received to Today] ENDIF