Replace a range of Numbers

[rwicker]

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.

[CharlieS]

EDIT: I misread the post. Follow @MarqueeCrew's instructions.

[MarqueeCrew]

Here's the issue: an integer only holds the values 0-9. That plus sign means that you're working with a string. So you can either use a select beforehand and change to a string or create a new string variable.

IIF(tostring([intVar]>5,"5+",[intVar])

Cheers,

Mark

[rwicker]

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!

[tom_montpool · Accepted solution]

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