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.
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!
