Teradata - Removing Banker's Rounding with changing settings

Question

I need to mimic a calculation in excel. We have to get the excact answer. The calculation is rounded at several points. Excel round X.5 up. It looks like Teradata is using banker's rounding (round X.5 to the even #).

I cannot change the setting in the company database. Is there any syntax I can use?

I have a temporary fix with a case statement but am hoping there is a better solution.

Thanks!

Answer 1

set RoundHalfwayMagUp to TRUE in dbscontrol.