Percentage Values are not displayed correctly when Calculated Item feature
I have developed an OBIEE answer with multiple pivot tables. Each of the Pivot Tables contains a mix of $ Amount and Percenatge columns. I have to display the totals as the last row of each Pivot Table. For reasons I am yet to figure out, some of the totals were not working. Hence, I used the "Calculated Item" feature with sum(*) as the formula to get the Totals. This is giving me the correct results for $ Amount columns but not for the % columns.
The system seems to be summing up the row-level percentages to arrive at the total percentage, which is not the expected bhavior.
Sample data:
Products| Dist. FG| VPE %| Mfg. FG| Mfg. FG VPE %
---------------------------------------------------------------------------------
Product1| $58| 1% | $1 | 100%
Product2| $45| (0%) | $36 | 24%
Product3| $22| 0% | $12 | (40%)
Product4| $1 | (0%) | $9 | 0%
Product5| $41 | 2% | $15 | 15%
Total | $166 | 3% | *$73* | *100%*
Total - Calculate Item (sum(*))
Total Mfg. FG - Correct
Total Mfg FG VPE% - Incorrect (Expected value is ~ 9 %)