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

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


      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.


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