Hi All,
Percentage Grand total is incorrect in OBIEE Analysis Report.
Version : OBIEE 11.1.1.141014
I am getting Percentage Grand Total as 100.52 %. Actually it should be 100 %
Formula applied in that column is CAST((COUNT("WRH Violations"."STAFF_CODE")/SUM(COUNT("WRH Violations"."STAFF_CODE")))*100 AS DOUBLE).
Disable the "Report based column" option and enabled the "server complex aggregate" option. But still unable to fix this issue.
Kind Regards,
Mohan
| 2016 Quarter 1 | MAERSK ENFIELD | 0.00 | 77 | 9.94% |
| ZIM INDIA | 0.00 | 56 | 7.23% |
| MAERSK EUBANK | 0.00 | 50 | 6.45% |
| PACIFIC ZIRCON | 0.00 | 48 | 6.19% |
| HYUNDAI NEW YORK | 0.00 | 46 | 5.94% |
| MOZAMBIQUE | 0.00 | 43 | 5.55% |
| NOBLEWAY | 0.00 | 39 | 5.03% |
| DAVIS SEA | 0.00 | 33 | 4.26% |
| LAKE KIVU | 0.00 | 31 | 4.00% |
| SULU SEA | 0.00 | 27 | 3.48% |
| LIGURIAN SEA | 0.00 | 26 | 3.35% |
| THURINGIA | 0.00 | 21 | 2.71% |
| KORO SEA | 0.00 | 19 | 2.45% |
| OSAKA TOWER | 0.00 | 17 | 2.19% |
| BLACKPOOL TOWER | 0.00 | 16 | 2.06% |
| MARMARA SEA | 0.00 | 16 | 2.06% |
| BANDA SEA | 0.00 | 15 | 1.94% |
| YELLOW RAY | 0.00 | 15 | 1.94% |
| PACIFIC DIAMOND | 0.00 | 13 | 1.68% |
| GOLDEN RAY | 0.00 | 12 | 1.55% |
| HANJIN NEW JERSEY | 0.00 | 11 | 1.42% |
| ANDAMAN SEA | 0.00 | 9 | 1.16% |
| MARITIME JEWEL | 0.00 | 9 | 1.16% |
| CATALAN SEA | 0.00 | 8 | 1.03% |
| KARA SEA | 0.00 | 8 | 1.03% |
| CEYLON | 0.00 | 7 | 0.90% |
| ROSS SEA | 0.00 | 7 | 0.90% |
| CAPE ALBATROSS | 0.00 | 6 | 0.77% |
| BELLA | 0.00 | 5 | 0.65% |
| CELTIC SEA | 0.00 | 5 | 0.65% |
| CORAL SEA | 0.00 | 5 | 0.65% |
| CUMBRIA | 0.00 | 5 | 0.65% |
| JAKARTA TOWER | 0.00 | 5 | 0.65% |
| KENT | 0.00 | 5 | 0.65% |
| TRIUMPH | 0.00 | 5 | 0.65% |
| ARAL SEA | 0.00 | 4 | 0.52% |
| NECTAR SEA | 0.00 | 4 | 0.52% |
| PACIFIC ONYX | 0.00 | 4 | 0.52% |
| PUSAN | 0.00 | 4 | 0.52% |
| BAVARIA | 0.00 | 3 | 0.39% |
| BLUE SKY I | 0.00 | 3 | 0.39% |
| CAP ARNAUTI | 0.00 | 3 | 0.39% |
| CSAV RIO AYSEN | 0.00 | 3 | 0.39% |
| HANDAN STEEL | 0.00 | 3 | 0.39% |
| HYUNDAI LOYALTY | 0.00 | 3 | 0.39% |
| SERENE SEA | 0.00 | 3 | 0.39% |
| BOTSWANA | 0.00 | 2 | 0.26% |
| CAMBRIDGE | 0.00 | 2 | 0.26% |
| GREEN RAY | 0.00 | 2 | 0.26% |
| MAERSK EFFINGHAM | 0.00 | 2 | 0.26% |
| PACIFIC BERYL | 0.00 | 2 | 0.26% |
| EBONY RAY | 0.00 | 1 | 0.13% |
| FAIRWAY | 0.00 | 1 | 0.13% |
| GUOFENG FIRST | 0.00 | 1 | 0.13% |
| HYUNDAI MERCURY | 0.00 | 1 | 0.13% |
| LAIWU STEEL HARMONIOUS | 0.00 | 1 | 0.13% |
| OSAKA CAR | 0.00 | 1 | 0.13% |
| PACIFIC QUARTZ | 0.00 | 1 | 0.13% |
| SAVANNAH | 0.00 | 1 | 0.13% |
| Grand Total | 775 | 100.52% |
