Demand forecast populating issue

BapinB

Hello Members , 

 

While in the " DEM3 Demand Forecast Module " I am facing an issue . By Applying the below formulae 

 

IF

    'SYS01 Time Settings By Week'.'1st Forecast Year?'

THEN

    'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year'

ELSE

    0

 

I am able to populate " Base line forecast " for FY20 weekly . But I am not able to populate FY 21 weekly . How will I be able to do that . 

 

Attaching two screenshots for better understanding 

 

Thank you and Regards 

jagadishdash

@BapinB 

First understand the learning they given, and refer that pic in the learning. They clearly shown that, If first forecast year then DAT03 historic volume of 1st year else (FY21) default forecast of 19that means you need to use the LAG function in Else statement for default forecast. See the Picture they shown with arrow.

 

I given clear hint to you, try first with formula and what i  told. If you're unable to get after trying also. let me know.

Understanding of the problem and how to crack it is important.

 

Hope it helps for you.

 

Thanks,

 

Jagadish dash

 

 

BapinB

Thanks Jagdish . 

 

Actually i have understood the Diagram and I also Know that Default forecast should be the Baseline forecast of FY 21 , but cant really figure out the actual formulae 

 

The syntax is not clear 

jagadishdash

@BapinB 

Well, refer the formula below. Hope you understood the concept. 

 

IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG(Default Forecast, 52, 0, STRICT) ELSE 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year'

 

Hope it helps for you.

 

Thanks,

 

Jagadish Dash

BapinB

Lots of Thanks Jagdish . 

 

Actually had no idea of LAG function . With your help got to know about the same .

 

Thank you very much 

jagadishdash

@BapinB 

My Pleasure.

Just go through Anapedia for detailed understanding the function. for your reference.

 

 

Thanks,

BapinB

Hi Jagdish , 

 

Thanks for Everything . 

 

I just have one issue explained below .

 

I am developing the UX through MY page and creating from there so How will I do the following in UX page 

 

Add permissions that allow this role to make changes to the Demand Forecast module for their assigned accounts and to view the other data on the Detailed Demand Review UX page. 

 

Can You Please help ? Thanks 

jagadishdash

@BapinB 

For this, you need to go to users>>Roles-Module>> there you can see already created roles. with respect o that role you need to give read and write access.

for ex: can make changes the demand forecast module. that means you need to give write access to that module under respective role they asked for.

and view the detail demand means you need to give only read access to that module.

 

Hope it helps for you.

 

Thanks,

 

Jagadish Dash

 

BapinB

Hi Jagdish , 

 

I have done that , but I was asking what needs to be done in the case of UX pages if Made through " My Pages " 

 

Thanks 

jagadishdash

Look, Through my Page only you are creating the UX page. and the requirement you mentioned that is access related to module no to the UX page. 

UX page access restriction is different, which you can find in page setting. to restrict access the particular Page.

 

Hope you got it.