3 Replies Latest reply: May 16, 2012 1:29 AM by Kalyan Chukkapalli RSS

    OBIEE 11.1.1.6 - Requirement is to show 3 digits after the decimal point.

    937463
      Hi,

      I have a requirement to concat 2 columns ( 1st column is a text column and 2nd column is a numeric column set as double in RPD). For the 2nd column, user wants to see 3 decimal digits all the time.
      For example, if the value is 2.4567 then I need to show round off value 2.457 and if the value if 3.4 , then I need to show 3.400 and if the value is 4 then I need add decimal point and show 4.000.

      Please let me know how I can achieve using OBIEE application without having to go through RPD.

      Thanks
      Swarna

      Edited by: 934460 on May 15, 2012 12:48 PM