1 Reply Latest reply: May 1, 2012 11:16 AM by Sunil Chauhan RSS

    Round Millions to #.#M

       

      Sometimes you'll want to display millions in a shorter format.  For instance, I may want $23,685,325 to display as $23.6M in my chart.  In order to do that, in your Expressions tab, you'll need to divide your number by 1M and then go to the Number tab, choose your expression, choose Money as Number Format Settings, and in the Format Pattern box, enter this custom format:   $#.#M



       

       

       

      Thanks!



       

       

       

        • Round Millions to #.#M
          Sunil Chauhan

          $23,685,325 /1000000

           

           

          expression divided /1000000                                  // as 1 M$=1000000$

           

          go to number in chart properties  select fieldname ->fixed to 2-> in text write $ before

           

           

          apply

           

           

          hope this helps