# If fiscal period = future fiscal period, times value by prior month's fiscal period growth

1. ## If fiscal period = future fiscal period, times value by prior month's fiscal period growth

Hi there

I have a forecast in calendar dates and fiscal periods. I would like to adjust forecast for growth, based on combination of country and fiscal period

My "argument" is = if fiscal period is the current fiscal period, do not apply growth rate (i.e. times by 1), if fiscal period is in future than times figure by the growth number for that country from one month ago for that future fiscal period

So...

if current fiscal period is 2020P10 and the forecast we are looking at is fiscal period 2020P10, do not apply growth number
If current fiscal period is 2020P10 and the forecast period is 2020P12, apply growth rate from one month prior to forecast period, i.e.,2020P11, for that country

I've done a manual calculation tab if that helps to illustrate

Tab 1 = is where I want it to pull data from the Forecast tab times the growth argument above
Tab 2 = is the forecast data
Tab 3 = is the source data for the country and fiscal period growth. In A1:B3, I thought a IF formula could use whatever value is here to calculate whether to apply a growth number or not, i.e., if we adjust the current fiscal period here, than a formula on the front tab could use this for it's IF-based formula?
Tab 4 = just a manual calculation as to end result, in terms of values

Thanks!

Apologies, also posted here:

2. ## Re: If fiscal period = future fiscal period, times value by prior month's fiscal period gr

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

3. ## Re: If fiscal period = future fiscal period, times value by prior month's fiscal period gr

Originally Posted by AliGW

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1