9 Replies Latest reply on Feb 26, 2019 10:04 AM by Joe Oppelt

    Change to different number formats

    Hemakumar Kandappan

      I have few metrics and an absolute value for each of them. As of now, all the absolute values are in number format. I need some metrics to be displayed as a percent while some as seconds.

       

      Example:

      metric abc - 1000 secs ( Present value 1000)

      metric cs/cs14 - 10.01% (Present value 1001)

      Note:  I have an extract connection.

       

      I know I have to create a calculated field and write a case statement. I tried doing that but I'm not getting it. Please help me.

       

      Thanks in advance