Hi gurus. I'm not sure this is the right space to ask this, but I have a BW query that displays several formulas in lines, and the columns are dinamically assigned according to the selected month range.
Two of those formulas are acumulated sums of other two key figures.
A third formula is the percentage of those acumulated values by month.
For example...
Month01 Month02 Month03
KeyFigure1 10 20 23
KeyFigure2 15 30 15
AcumKF1 10 30 53
AcumKF2 15 45 60
% Acum 66.67 66.67 88.33
Where % Acum = (AcumKF1 * 100)/AcumKF2
Both AcumKF1 and AcumKF2 are formulas with the acumulated check marked on the formula definition.
However, when I execute the query, the % Acum does not use the acumulated values to calculate the percentage, instead it uses the original values, so the percentage is not what's expected... Something like this:
Month01 Month02 Month03
KeyFigure1 10 20 23
KeyFigure2 15 30 15
AcumKF1 10 30 53
AcumKF2 15 45 60
% Acum 66.67 66.67 153.33 <----- THIS IS WRONG !
Any ideas how I can solve this???
Thanx in advance