IF Function in the Formula Tool - Not pulling the correct column of data that it should be

[katos]

This is from the Select tool showing all of the data types. 

This is the formula.

But when I run it, it's giving me the Local amount instead of the USD amounts for account "2822"

Any ideas on what's happening or how to fix this issue?

[acarter881]

Hey @katos. That formula should work. Are there extra characters in the "Company" field? For example, have you trimmed leading and trailing whitespace from the "Company" field? If so, I would expect your formula to work as intended. If not, it will return the "ELSE" value.

[MilindG]

Weird, Its working for me right. 

[katos]

I just used a data cleansing tool and replaced all whitespace (I don't think there was any but worth a try) and now some of them are pulling correctly but some are now showing as null. Any thoughts on that?

[katos]

That's so strange. I cannot figure out what's happening.

[acarter881]

I can resolve it with a sample of the data, if you'd like.

[MilindG]

@katos  Its prob showing null because your feild type. Perhaps change it to Int32

[katos]

Okay that worked for just account "2822". When I added in 2 other account numbers (I tried making them their own formulas and by using OR and now it's doing the same thing for the other 2. Am I writing this formula wrong? 

[MilindG · Accepted solution]

@katos  try this

[katos]

That worked! Thank you so much!