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 wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…