7 Replies Latest reply: Apr 2, 2013 9:45 PM by Kasyap RSS

    obiee rounding issue

    JV123
      Hi,

      grand total ...total average for calendar days to last shipment is wrongly calculating...obiee showing 19 but when I calculated average in excel it would be 15.9....obiee displaying 19 instead of 15.9. I guess it would be rounding problem that reflects in total. do you know how to fix rounding issue in obiee 11.1.1.6.2?



      PARENT NAME     STYLE     DESCRIPTION          QTY AVG(CALENDAR DAYS TO LAST SHIPMENT)
      IRON MOUNTAIN RECORDS (PARENT)     3919     IRON MOUNTAIN HYPERKEWL CAP     197     20.0
      IRON MOUNTAIN RECORDS (PARENT)     2017     65/35 DRESS CARGO PNT          180     10.0
      IRON MOUNTAIN RECORDS (PARENT)     3996     IM SHREDDER POLO          97     58.0
      IRON MOUNTAIN RECORDS (PARENT)     2519     WMNS INDUSTRL CARGO PANT          48     16.0
      IRON MOUNTAIN RECORDS (PARENT)     82025     S365 WP Arctic System Parka          44     15.0
      IRON MOUNTAIN RECORDS (PARENT)     760     GORGONZ LIGHT DUTY GLOVE          31     9.0
      IRON MOUNTAIN RECORDS (PARENT)     7160     GARRISON BELT          21     11.0
      IRON MOUNTAIN RECORDS (PARENT)     3912     COOLING VEST          19     33.0
      IRON MOUNTAIN RECORDS (PARENT)     1085     CLASS 2 VEST          11     28.0
      IRON MOUNTAIN RECORDS (PARENT)     2069     65/35 DRESS FLAT PNT          10     4.0
      IRON MOUNTAIN RECORDS (PARENT)     5216     BOA SAFETY GLASSES          10     5.0
      IRON MOUNTAIN RECORDS (PARENT)     2127     5.11 TACTICAL MALE PANTS          8     8.0
      IRON MOUNTAIN RECORDS (PARENT)     405     4-LAYER PARKA          3     8.0
      IRON MOUNTAIN RECORDS (PARENT)     2174     PROWEIGHT 1/4 ZIP WR SWEATSHIR 2     5.0
      IRON MOUNTAIN RECORDS (PARENT)     4855     TIMB PRO 6" ALLOY TOE          2     8.0
      Grand Total                    683     19.0