WeBi Forecast with multiple dimensionvariables

[denis_konovalov]

I have a problem, when I make a forecast for a economic development.

For the forecast, I want to make a variable, that takes the average spending for the last 12 month and fill the future month.

The variables i have made is:

=If ( [actual spending]=0; RunningSum([actual spending] Where ([rolling month] <12))/12;[actual spending])

When I use this, it works separately for every single dimension-variables, but when I choose to show to or more dimensions-data as input, it makes it wrong.

It is a success for a one dimension variable, but when I expand the dimension for multiple underneath variables/dimensions for the dimension, it makes some funny results, like it is making a sum across the underneath variables/dimensions

Anyone got an idea?

Best regard

Andreas

[denis_konovalov]

I have removed irrelevant tags, please select more carefful in the future

[ayman_salem · Accepted solution]

Your formula should look like this:

T: =If ( [actual spending]=0; RunningSum([actual spending] Where ([rolling month] <12) ;([DimN]))/12;[actual spending])

...

where [DimN] is the object for dimension 1, 2, 3, .....

....

hope this solves your problem