Dynamic Number Formatting By Rody Zacovich

Recently I saw some examples of Dynamic Number Formatting on Twitter, so I though I’d share a solution I came up with a few years ago.This solution uses some simple math to determine the base 10 of a number. Using that base 10 we can determine how to round it, and which numeric symbol it should have. Solution also removes 0 decimals, and handles negatives.Copy/Paste this calc and change [Value] to the field you want to have dynamically formatted. NOTE* we are aggregating in the calc, so if you want to dynamically display a value that is MAX/MIN/AVG/ETC, change the aggregation in the formula.

Read Original Article…