Rounding Calculations in Tableau (and Excel and Alteryx)

I was doing some table calculations in Tableau and needed complete control over the rounding that was used.┬áTableau provides a single ROUND function. The exact specification of this (I believe) depends on the data source you are connected too, as it passes through to the underlying server. I needed to be able to look at…