Update column based on 2 other columns

z-rising 

i think the bracket for orginial sort is wrong, pls try

[ Original Sort]

Hi z-rising ,

ryan_mayu Thanks for your concern about this case!
And In addition to what ryan_mayu  said, I would like to remind you that you are using "12345" and "67890" in your code, I am not sure what kind of data you have, but the addition of " " means it is a text type column. If you say that these two columns should be of type Number, then you need to remove the "".

About "An added layer of complexity is that I need this for 4 different Cost Center No values, though all the same Account, hopfully without creating 4 different new columns." Can you show us your data and the expected results? Maybe we can help you find a quicker solution.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.