Unable to calculate sum of percentages in BI Publisher
Hi,
In BI Publisher, the sum of my column containing percentages is literally calculated and logically wrong.
For example, when C=(B/A) X 100 ,the results should be as below:
A | B | C
-------------------------|-------------------------|-------------------
-$159,465,537.00 | $0.00 | 0.00%
| |
$143,125,953.72 | $3,597,312.35 | 2.51%
-------------------------|-------------------------|-------------------
-$16,339,583.28 | $3,597,312.35 | -22.02%
But in BI Publisher my results are as below:
A | B | C
-------------------------|-------------------------|-------------------
-$159,465,537.00 | $0.00 | 0.00%
| |
$143,125,953.72 | $3,597,312.35 | 2.51%
-------------------------|-------------------------|-------------------
-$16,339,583.28 | $3,597,312.35 | 2.51%
As you can see my percentages are summed up which is the wrong result.
Kindly let me know if you have a solution