Can we do Perform Number formatting on the data

Follow

Kranthi Kumar Sreeram

• April 25, 2018 12:12

I would like to do number fomatting based on  the results Dervied in the worksheets.

 

Example : 1 to 100%

 

Is there a way. Plz guide me

0

• 

  Alan

  • April 25, 2018 14:44

  Hi Kranthi,

  You'd just need to use the CONCAT formula and do the standard multiplication necessary to convert to percentage.

  CONCAT((#Sheet!Column*100);"%")

  So, 1 would become 100 and then % would be concatenated.  Likewise 0.9 would become 90 and then % would be concatenated, etc.

   

   

  0

  Comment actions Permalink
• 

  Kranthi Kumar Sreeram

  • April 26, 2018 07:57

  Hi Alan,

   

  Thanks for the note, As a workaround I had used the same and this changes the datatype of the Filed and hence I am not able to make further aggregations or info graphics using the same filed. 

   I don't want to change the datatype.

  0

  Comment actions Permalink
• 

  Joel Stewart

  • April 26, 2018 17:24

  The available formatting options for number types are documented here: Formatting Columns notably the only available options are to include a thousands separator and to control the number of decimals displayed. Customized display formatting beyond that is not available currently.

  0

  Comment actions Permalink

Please sign in to leave a comment.