SravanKumar
Occasional Contributor

2.3.10活动:创建需求预测

As per the below activity information provided, do we need to write the formulas for all the line items in the module or need to write the formula for only Growth Rate % line item?

SravanKumar_0-1638506306152.pngSravanKumar_1-1638506359136.png

Can anyone provide clarity on this activity for me?

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

@SravanKumar

For all line items and not just Growth rate%.

Baseline Forecast = Data available in one of the DAT modules

Default Forecast = Use Growth Rate and Baseline Fcst to arrive at Default Forecast

最初的DF= Use ROUND function on Default Forecast

Hope that helps

Misbah

Miz Logix

View solution in original post

4 REPLIES4
Misbah
Moderator

@SravanKumar

For all line items and not just Growth rate%.

Baseline Forecast = Data available in one of the DAT modules

Default Forecast = Use Growth Rate and Baseline Fcst to arrive at Default Forecast

最初的DF= Use ROUND function on Default Forecast

Hope that helps

Misbah

Miz Logix

Dijones128
Contributor

Hello,

Can someone help me figure what I am missing in my formula? I've tried several formulas and I don't think is the exact formula I'm suppose to use.

I'm sharing my formula's and my DEM03 module.

Dijones128_0-1642108279813.pngDijones128_1-1642108314843.png

shady10
Occasional Contributor

Hi@Dijones128

We already determined the forecast in the DAT03 Module so you just need to pull the "Offset Volumes for 1st Forecast Year" data

shady10_0-1642191494280.png

Dijones128
Contributor

Thank you for your reply, I ended up get my formulas but for some reason all of my data isn’t displaying