Contributor

## How to calculate forecast percent based on latest 3 months (average) actuals?

Hi,

Current setup:

I have a source module where I will get actuals percents every month. The module doesn't include the version dimension/list.

Target module:

I want a module that includes version actual, forecast, and probably later other versions as well. I would like to get from the source module the actual (allocation % = line item). For the forecast version, I would like to calculate rolling forecast % which will be based on the latest 3 months average.

The picture attaches will illustrate my need for concrete.

Thanks in advance,

A

1 ACCEPTED SOLUTION

Accepted Solutions
Master Anaplanner/Community Boss

## Re: How to calculate forecast percent based on latest 3 months (average) actuals?

Hi antti.kerola@elisa.fi

I don't see the picture but if I understand correctly, a MOVINGSUM  formula would do the trick. you would have to divide by 3 to get the 3 months average.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
2 REPLIES 2
Master Anaplanner/Community Boss

## Re: How to calculate forecast percent based on latest 3 months (average) actuals?

Hi antti.kerola@elisa.fi

I don't see the picture but if I understand correctly, a MOVINGSUM  formula would do the trick. you would have to divide by 3 to get the 3 months average.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Contributor

## Re: How to calculate forecast percent based on latest 3 months (average) actuals?

There is a picture available now.