Can we do Perform Number formatting on the data

3 followers
0
Avatar

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

Kranthi Kumar Sreeram

3 comments

  • Avatar
    Alan Mark

    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
  • Avatar
    Kranthi Kumar Sreeram

    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
  • Avatar
    Joel Stewart

    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.