formulae help

[ManuelRodrigues]

Hi Team,

I have this Formula in Alteryx but when i replicate this in excel the results are different any help much appreciated? Note Alteryx result is correct but same formuale in excel does not work as Alteryx.

Thanks in advance!

[Maskell_Rascal · Accepted solution]

Hi @ManuelRodrigues 

I can't seem to replicate the issue you're having with Alteryx vs Excel. I suspect that your results in Alteryx are getting cut off due to the field size being set to 9. In any case, I used both your formula and a slightly simplified version of it to check the results. Both came out the same. 

Double check your field size and adjust it up if needed. 

If this solves your issues please mark answer as correct, if not let me know!

Thanks!

Phil

[apathetichell]

Is the first part of your IF statmenet supposed to be left(left())? That's redundant.

[ManuelRodrigues]

Thanks Maskell!