5 Replies Latest reply on Jun 13, 2013 1:07 PM by Trey Beale

    Number Formatting

    Trey Beale

      is there a supported way to convert a % to a base point value. For instance, if YoY growth is up "10%", i would like to display this as "10bps"

        • 1. Re: Number Formatting
          Justin Emerick

          Hi Trey,

           

          Welcome to the forums! First, isn't a basis point .1% 10% would be 1000bps...

           

          Just create a calc field like this:

          [Percent Measure Column]*10000

          If a bps in your org is 1% than use:

          [Percent Measure Column]*100

          *where [Percent Measure Column] is the Measure that has your percentage.

           

          For the label, you can "edit axis" by right clicking on the axis and add a Subtitle "bps" or you can create a calc field like this:

          str([Percent Measure Column] )+" "+"bps"

           

          Hope that helps!

           

          Justin

          1 of 1 people found this helpful
          • 2. Re: Number Formatting
            Justin Emerick

            I spoke to soon,

             

            There is one more way to do this.

             

            You still need to create the calc field that multiples the percent measure column by either 10000 or 1000.

            After you do this, right click on your newly created calc field and select "Field Properties"> "Number Format"

             

            In the Number Format menu, choose "Number (custom)" and add the suffix " bps" (notice the space before bps).

             

            This will adjust the label and the axis and represent your number in "bps."

             

            Justin

            1 of 1 people found this helpful
            • 3. Number Formatting
              Shawn Wallwork

              Yes. Set up your YOY growth table calc the way you want it. Then go into the Edit Formula:

               

              Edit formula.png

               

              Copy the formula, then cancel back out. Now create a new calculated field, and paste in the formula. Then multiple the entire formula by 100.

               

              Percent Difference.png

               

              Now drop this on top of your first table calc so it replaces it. Finally, click the pull down of this pill and click Format. Go over to the Number format and create this:

               

              Format.png

               

              You'll end up this this:

               

              REsult.png

               

              Adjust decimals to taste.

               

              --Shawn

              1 of 1 people found this helpful
              • 4. Re: Number Formatting
                Shawn Wallwork

                But mine had pictures!

                 

                --Shawn

                • 5. Re: Number Formatting
                  Trey Beale

                  This was great....worked perfectly!!!