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

[ayman_salem]

Providing sample data and the expected result will help us understand your problem

[former_member700437]

examples-to-sap-community.jpg

Here you go.
The formula makes the wierd results at 2020-08 - a 12 months average with a maximum 156.000 danish crowns, can never be a average at 2 millions.

But if i delete the underneath dimension [Dimension 1,2,3 and 4] - and only have the [Top dimension] - it makes an average which looks like the real deal.