- Community
- :
- About rmat066sysf
Ask the Community
-
Ask a QuestionGet answers to platform specific questions from Anaplanners everywhere.
-
Suggest an IdeaShare ideas for platform improvements, training, the Community, and more.
-
Get Training HelpComplete your training with support from the experts.
-
Contribute ContentWorkshop content, submit for approval, and contribute best practices to the Community.
-
Connect with CommunityShare feedback, ask questions, and get support from the Community.
About rmat066sysf
since
08-26-2020
12-11-2020
rmat066sysf
Occasional Contributor
Activity Feed for rmat066sysf
- Posted How often do you set the sales revenue target? on Anaplan Platform. 09-30-2020 10:01 PM
- Posted Re: Monthvalue Formula on Anaplan Platform. 09-29-2020 11:00 PM
- Posted Monthvalue Formula on Anaplan Platform. 09-28-2020 08:04 PM
- Posted Re: Unable to upload Model history for Supply Chain Model after completing L2 MB Conclusion Exam on Anaplan Platform. 09-28-2020 06:35 PM
- Posted Unable to upload Model history for Supply Chain Model after completing L2 MB Conclusion Exam on Anaplan Platform. 09-27-2020 01:53 PM
- Posted Re: INV04 Distribution Center Capacity on Anaplan Platform. 09-22-2020 01:57 PM
- Kudoed Re: INV04 Distribution Center Capacity for Puneeth H P. 09-22-2020 01:57 PM
- Posted INV04 Distribution Center Capacity on Anaplan Platform. 09-21-2020 01:12 PM
- Kudoed Re: Model Builder 2/- TRA01 Shipping Time in Weeks for JussiLi. 09-19-2020 02:27 AM
- Posted Re: Model Builder 2/- TRA01 Shipping Time in Weeks on Anaplan Platform. 09-19-2020 02:26 AM
- Posted Model Builder 2/- TRA01 Shipping Time in Weeks on Anaplan Platform. 09-19-2020 12:27 AM
- Kudoed Re: Formula Error for Misbah. 09-17-2020 02:33 PM
- Posted Re: Data import of different Dimension on Anaplan Platform. 09-17-2020 02:13 PM
- Posted Re: L2 Supply Chain Model DEM01 & DEM02 on Anaplan Platform. 09-17-2020 12:36 AM
- Posted L2 Supply Chain Model DEM01 & DEM02 on Anaplan Platform. 09-16-2020 08:56 PM
- Posted Update Historic Volumes for Baseline Forecast on Anaplan Platform. 09-11-2020 11:47 AM
- Posted Re: Formula Error on Anaplan Platform. 09-08-2020 01:47 AM
- Posted Re: Formula Error on Anaplan Platform. 09-08-2020 01:18 AM
- Posted Re: Formula Error on Anaplan Platform. 09-08-2020 12:47 AM
- Posted Formula Error on Anaplan Platform. 09-08-2020 12:34 AM
18
Posts
0
Kudos
0
Solutions
09-30-2020
10:01 PM
Hi In ref to the above, Is there a particular time (month) of each year (if annual) that the organisation begins the goal setting by role? (Country Sales Targets etc)? If yes - should access be granted on/off for a limited time period in which the user begins/finishes the target setting process . I understand it lead to workflows but is that something that can be achieved ( approvals, alerts, handshakes/handoff's etc.). Just a thought ( not trying to overshoot the target). Thanks in advance. Thanks
... View more
Labels:
09-28-2020
08:04 PM
Hi Im revisiting my formulas and find that the output is the same with either A or B : Is there a difference between the two ? I want to apply the monthly growth values to weeks. A. MONTHVALUE('Volume Growth Rates'.Growth %) - WEEKVALUE('Volume Growth Rates'.Growth %) B. MONTHVALUE('Volume Growth Rates'.Growth %) Thanks for your response. Cheers
... View more
Labels:
09-28-2020
06:35 PM
Thank you. Reached out and they enabled the upload. Cheers
... View more
09-27-2020
01:53 PM
Hi Im unable to upload Model history for Supply Chain Model although Ive completed the Conclusion Exam. Is there anything missing/undone to be able to activate the link to upload the Model history file.
... View more
Labels:
09-22-2020
01:57 PM
Hi Thank for your response. Agreed. Checked the beginning inventory formula and it is good. Cheers
... View more
09-21-2020
01:12 PM
Hi My Capacity % numbers look weird, Am I missing something when calculating the beginning inventory. Pls refer to img. Appreciate your help. Thanks
... View more
Labels:
09-19-2020
02:26 AM
Thank you. It worked. Cheers
... View more
09-19-2020
12:27 AM
Hi Been trying to figure out this formula but unable to due to the Year to week Lookup criteria . Any suggestions pls The formula for 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)' is invalid: 'Shipping Time (Weeks)' = YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)' [LOOKUP: 'SYS01 Time Settings By Week'.Current Period?] Thanks in advance for your help and guidance. Lookup Ref: Source Target DAT02 Map TRA01 P2 Products Ok P2 Products Ship Methods Ok Ship Methods Year Lookup SYS01 Week
... View more
Labels:
09-17-2020
02:13 PM
Hi Vignesh Im trying to create a system module to identify years of the week as suggested with formula period(start()) but it gives an error. Appreciate your help Thanks
... View more
09-16-2020
08:56 PM
Looking for an opinion Is it best practice(DISCO) to have the following in a single module or is it preferred to have it in separate modules DEM01 & DEM02: Line 1 : Growth % by Month ( time set to month) Line 2: Growth % by Week ( time set to week) Thanks
... View more
Labels:
09-11-2020
11:47 AM
Hi Im trying to build the volumes for baseline forecast and below is my formula resulting in the following error IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast Year',-52,0) Appreciate your help. Thanks in advance The formula for 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' is invalid: 'Offset Volumes for 1st Forecast Year' = IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast Year',-52,0)
... View more
Labels:
09-08-2020
01:47 AM
IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 IF Employed? THEN 'EMP03 Employee Drivers by Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 IF Employed? THEN 'EMP03 Employee Drivers by Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 IF Employed? THEN 'EMP03 Employee Drivers by Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 Hi Misbah changed format to list:Role in SYS08 Attached are the screen shots of blueprint view, and the formula's that returns an error. Appreciate your help. Thanks
... View more
09-08-2020
01:18 AM
Hi Misbah SYS08 Data is imported from a emplee detail by role txt file that has Role populated, so the format cannot be a list:Role...i guess.
... View more
09-08-2020
12:47 AM
Thanks, that the screen shot of my formula. Thanks for your help, still get the same error.
... View more
09-08-2020
12:34 AM
Hi Pls can you help : ----------------------------------------------------------------------------------------------------------------------------------------------------- The formula for 'EMP02 Employee Expenses By Dept & Role'.Bonus is invalid: Bonus = IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 'EMP03 Employee Drivers by Role'.Bonus % is not a recognized line item or list member ----------------------------------------------------------------------------------------------------------------------------------- Is it something to do with the data type? if so is it in SYS08 or EMP03. Appreciate your help. Regards Richard
... View more
Labels:
09-08-2020
12:19 AM
Hi Im having the same issue, can you elaborate on the which module "Data Type was incorrect" pls. Regards Your Ref: Thank you, my lookups are working now, brilliant, my data type was incorrect.
... View more
Posts I kudoed
| Subject | Kudos | Author | Latest Post |
|---|---|---|---|
| 1 | |||
| 1 | |||
| 1 |