Sunday, January 30, 2011

Crystal Reports : Display currency values as millions of dollars

Let us suppose we are summarizing very large dollar values. This is common in the financial advice and investment industry, where "cases" are typically measured in millions of dollars.
It is very typical to show these values simply in millions of dollars. So, for instance, the number 325,000,000 becomes 325. 1,200,000 becomes 1.2. This can help also on a report that is starved for "real estate" (i.e. available blank space on the report).

So, our millions of dollars Running Total Field is called {#CASESAMOUNT}.

It would be a simple feat to create a Formula called {@AmountInMillions} thusly:

{#CASESAMOUNT} / 1000000