Skip to Content

To set Decimal Places in Design Studio

Hi All,

This document helps you to set Decimal places with Percentage in design studio by using Script.

Requirement:-

Create a Column Chart which shows data in decimal places.


         /wp-content/uploads/2014/07/1_506686.jpg



Steps:-

  1. Drag a column chart in to the application
  2. Assign Data source to it.
  3. Go to chart properties and disable the show value inside option.
  4. As we all know while setting decimal places in  the datasource (edit initial view) doesn’t make any changes, please find below link for the same

http://scn.sap.com/thread/3464895


       /wp-content/uploads/2014/07/2_506682.jpg


   5.  So the alternative way to make decimal places by  using script in Onstartup event.

   6.  For that we will drag text box on the Column chart, and assign default text (in decimal) for design view purpose

      /wp-content/uploads/2014/07/3_506683.jpg

  

   7.  Go to Application =>Event => On startup

   8.  Write a script to convert result to decimal number.

   9.  Create a variable, assign data to it and use convert function to that variable. Assign value of result to text box.


     /wp-content/uploads/2014/07/4_506684.jpg


  10.  Execute

    

       /wp-content/uploads/2014/07/5_506685.jpg


  11. While executing the Application it automatically pick the result from datasource. As I have assign 142.17 as default value in the text box in design mode, which automatically get updated by the Onstartup event on successful execution of dashboard.


  12.Similarly for Percentages (%):

                                        For example- If you want to show variance percentage between two column i.e. A and B

                                  var ZYOY1_VARIENCE = (DS_1.getData(“A”, {}).value – DS_1.getData(“B”, {}).value) / DS_1.getData(“A”, {}).value * 100;

                                  TEXT_PERCENTAGE.setText(Convert.floatToString(ZYOY1_VARIENCE,”#0.0″)+ “%”);

   13. Similarly we can do for Variance(-):

                                                  For example- If you want to show difference between two column A and B

                              var ZYOY1_VARIENCE = (DS_1.getData(“A”, {}).value – DS_1.getData(“B”, {}).value)

                              TEXT_Variance.setText(Convert.floatToString(ZYOY1_VARIENCE,”#0.0″);

Hope this helps….

Regards,

Tulika

7 Comments
You must be Logged on to comment or reply to a post.