4 Replies Latest reply on Oct 25, 2018 1:20 PM by Vijayalakshmi Pradeep

# Set Targets for next three years

Hi,

I've the data for 3 years as follows:

 Countries Employee Type Gender # of Employees Year XYZ Employee Male 63 2015 XYZ Employee Female 31.5 2015 XYZ Contingent Worker Male 472 2015 XYZ Contingent Worker Female 236 2015 XYZ Employee Male 700 2016 XYZ Employee Female 350 2016 XYZ Contingent Worker Male 421.4999 2016 XYZ Contingent Worker Female 2.1074995 2016 XYZ Employee Male 1500 2017 XYZ Employee Female 750 2017 XYZ Contingent Worker Female 446.9862 2017 XYZ Contingent Worker Male 223.4931 2017

I want to set targets for next 3 years ie., 2018,2019 and 2020. All countries are grouped as A,B and C. How can i use LOD for this... Need help..

Thanks

• ###### 1. Re: Set Targets for next three years

Hi Vijayalakshmi,

first add three years in your db with no data and then do the calculation

IF ISNULL(SUM([Sales])) THEN PREVIOUS_VALUE(SUM([Sales]))*(1+[Uplift on Actual])

ELSE SUM([Sales])

END

Refer

thanks

sankar

• ###### 2. Re: Set Targets for next three years

Hi,

I'm not sure how you decide the target, but if we call the projected sales using past growth and some adjustment, attached will work.

Basically this replicates what we usually do on Excel.

1. Create new measures of the sales in each year

2. Calculate growth rate

3. Create parameter to control the adjustment (if necessary)

4. Apply 2 & 3 on the sales of the last actual year

Best regards,

Hideki OGAWA

• ###### 3. Re: Set Targets for next three years

Hi Ogawa,

Thank you very much. It helped me a lot.

• ###### 4. Re: Set Targets for next three years

Hi Rajan,

Thank you very much. It works.

One more question. How to forecast when you know CAGR