3 Replies Latest reply on Aug 9, 2017 4:42 PM by Shinichiro Murakami

    Changing The Format of Two Measure Values from 6 Total

    Shawn Gerou

      I'm looking to build a report based on a cube of data and would like to be able to format the measure values. I have currently 4 and need to change the format of 2. If I format using the standard way it will just make them all the same. I'd like sales to have a currency and be in Millions with a 1 place decimal. Also I'd like value visits to be a percentage with one decimal.

       

      Hoping this can be done.

       

      I saw Pooja's piece which seems fruitful but no avail. and tried a few others

      Need REGEXP_REPLACE to add thounsands seperators

       

      Here is an example of some dummy data. (WTD MTD, QTD are all measure values)

       

      Thanks for the help