Skip to Content
0
Former Member
Apr 13, 2012 at 10:01 PM

Problem in a BW Query Formula

29 Views

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