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…

Comments and Whitespace in Excel Formulas

A couple of silly little tricks, but ones I find useful. Far too often I end up trying to decode a complicated Excel formula and wanting to make it easier to read and leave comments behind. The tricks below work in Excel 2010 and 2013. I don’t use 2007 any more but expect they would…