2 Replies Latest reply: Sep 9, 2011 7:43 AM by Sokkorn Cheav RSS

    numeric format of calculated dimension?

    Sushil Kumar

      Hi All

       

      I have a calculated a dimention as =aggr((Sum({<DT_TYPE=>}NDFNDR_SUMMARY.TOTAL_DEFECTS)/Sum ({<OP_VERNUM={1},DT_TYPE=>}total<OT_DESCRIPTION> TOTAL_UNITS_PROCESSED)*100)),NDFNDR_SUMMARY.MT_TYPE)

       

       

      the results are comming as 1.3837418378

       

      but i want the result format as 1.38 means upto 2 decimal point..

       

      how this can be achieved...

       

      Thanks