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?
@katos try this
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.
Weird, Its working for me right.
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?
That's so strange. I cannot figure out what's happening.
I can resolve it with a sample of the data, if you'd like.
@katos Its prob showing null because your feild type. Perhaps change it to Int32
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?
That worked! Thank you so much!
@katos Cheers!
