Most of the time, I want to report my financials in either Thousands or Millions. Although I could likely add a "/1000" or "/1000000" to my formulas, I prefer to maintain the integrity of the original data by just displaying in either thousands or millions (rather than changing the numbers themselves). Is there a way to do that today?
No, there's no way to do that without dividing. This is a recurring problem and the only way round it is to come up with a consistent naming convention for your thousands, millions etc., and sticking to it.