13 Replies Latest reply on May 23, 2017 8:24 AM by Okechukwu Ossai

    How to Convert Number to Str as a dimension

    Ram Atmakuri

      Hello Friends,

       

      I am trying to convert a number to a string with two decimals and get the result as a dimension, but am not able to get the desired output and could anyone please help how to do that? The reason I am specifically looking to get this as a dimension because I want to use this field to establish relationship with a different data source. Attached is the dashboard to show what I am trying to do.

       

      Sales - Number value

      Str - Converted to str and getting this calc field dimension but not able to restrict it to 2 decimals

      str1 - Able to restrict it to 2 decimals but not able to get this field under dimension.

       

      Need your guidance and support to fix this friends