Hi,
My name is Usha Priya. I am trying to add formulas to the SYS01 Time Settings by Year System module. I get a message saying the formula is invalid. Please find below the screenshot. I need some help to solve this issue. Thanks.
Thank you very much for your help. I wrote the formula referencing line items directly by clicking on them as suggested by you and it worked. Problem solved. I really appreciate your help. Thank you.
@UshaPriya
You are getting this error because Anaplan is unable to locate 'Forecast Period?' line item in 'SYS00 Time Settings' Module. Make sure you have created it before using the same here in the formula.
~Anand
Thank you very much for your reply. I have already included Forecast Period as a line item in 'SYS00 Time Settings' Module but still I get the error message.
Could you please post the snip of SYS00 Module showing the line items in the bluprint view please.
Please find below the blueprint view showing the line items of SYS00 Module.
Did you copy the formula from the training materials?
Do not do this as the formula relies on the use of correct spelling as per your model.
Instead, write the formula out from start to finish referencing line items directly by clicking on them as you construct the formula.
Hello All,
Thanks for the solution, I'm in the intial stages of learning Anaplan. I got the same error while adding the formulas to the 'forecast Year?' in the module SYS01 Time settings by year. I added the formula by reference , but still I'm getting the same error. The attached screenshot for your reference. It would be helpful, if someone could help me in resolving the issue.
Regards,
Karthiega Vinoth
@Karthiega you are using the formula 'SYS00 Time settings.Forecast period? which is apparently "Module Name"."Line item Name". you have named your module only "SYS00". Instead of copy pasting the formula double click on formula reference on your module and go to "SYS00" module and click on Forecast period? Line item. it is better if you name your module "SYS00 Time Settings" instead of "SYS00". since this is training you might get the questions to provide the formula. The answer will be wrong because your naming is wrong.(although technically your answer would be right.)Thanks,Manjunath
Hi Manjunath,
Thank you very much for your guidance. I recreated a module with the name 'SYS00 Time setiings' and added the formula as suggested by you and it worked, the problem was resolved. I really appreciate your help.
Thank you.
Hi, I would like to specify in an Anaplan Connect script that UTF-8 text encoding should be used for the file I am uploading. Does anyone know the command for this, or another way to make this happen? Thanks!
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
