cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in a BW Query Formula

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186082
Active Contributor
0 Kudos

Hi

Check if different formulas are colliding at that particular cell

Regards

Chandu

Former Member
0 Kudos

Hi Chandra.  Thanks for your response.

I'm not using cells... The columns are selected by the user acording to a range as a select parameter. It is done dinamically, so I can't use cells to fix them.