建模

了解如何构建提供最佳结果的高效模型。

讨论表

"},"updateUserID":null,"lastUserID":91665,"lastUser":{"userID":91665,"name":"AkhilEmmanual","url":"https:\/\/community.anaplan.com\/profile\/AkhilEmmanual","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/LBZINBMUGD35\/n3KYKRYIUA3HB.png","dateLastActive":"2023-06-17T17:52:41+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":3374017610,"url":"https:\/\/community.anaplan.com\/discussion\/155983\/problem-with-circular-reference","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155983\/problem-with-circular-reference","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/0R85CMNT6LCA\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-17T17:09:51+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155971,"type":"question","name":"remove double counting of projects","excerpt":"Anaplanners, I have a query on how i can remove double counting of Projects. Case artifacts: T1 Teams, which is a hierarchical list, so for example Team A.1 & Team A.2 rolls up to Team A, like wise Team B.1 rolls up to Team B; all rolling up to total teams. M1 Members: Flat member list. P1 Projects: a Numbered list of…","categoryID":19,"dateInserted":"2023-06-15T10:27:02+00:00","dateUpdated":null,"dateLastComment":"2023-06-17T14:59:48+00:00","insertUserID":51812,"insertUser":{"userID":51812,"name":"Sachinsourav02","url":"https:\/\/community.anaplan.com\/profile\/Sachinsourav02","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/51812.png","dateLastActive":"2023-06-16T08:36:52+00:00","banned":0,"punished":0,"private":true,"label":""},"updateUserID":null,"lastUserID":3020,"lastUser":{"userID":3020,"name":"TristanS","url":"https:\/\/community.anaplan.com\/profile\/TristanS","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3020.jpeg","dateLastActive":"2023-06-17T15:47:49+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":38,"score":null,"hot":3373840610,"url":"https:\/\/community.anaplan.com\/discussion\/155971\/remove-double-counting-of-projects","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155971\/remove-double-counting-of-projects","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-16T12:56:28+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":48,"urlcode":"Model-Builder","name":"Model Builder"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155882,"type":"question","name":"calculate time settings with out hard coding","excerpt":"HI All, I want achecive below attached scenario without hard code. in source if i enter y the result should be start week and end week start week can find out by current period () and how can i find out end week without adding +52 or 53 same applice to below scenario y-1","categoryID":19,"dateInserted":"2023-06-06T08:06:03+00:00","dateUpdated":null,"dateLastComment":"2023-06-16T16:46:11+00:00","insertUserID":78982,"insertUser":{"userID":78982,"name":"kishoreanimi","url":"https:\/\/community.anaplan.com\/profile\/kishoreanimi","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/78982.png","dateLastActive":"2023-06-11T15:41:19+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":12489,"lastUser":{"userID":12489,"name":"AjayM","url":"https:\/\/community.anaplan.com\/profile\/AjayM","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/2WH9L4BNP18W\/n6X0H5VUY6ILY.jpg","dateLastActive":"2023-06-16T20:05:34+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":38,"score":null,"hot":3372973334,"url":"https:\/\/community.anaplan.com\/discussion\/155882\/calculate-time-settings-with-out-hard-coding","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155882\/calculate-time-settings-with-out-hard-coding","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/XUAHRF4Q67QW\/capture-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-16T16:46:11+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155981,"type":"question","name":"Erlang C- Application","excerpt":"Hi! I am leveraging Erlang C for a staffing model. As I use Erlang C the service level that Anaplan is calculating is producing inconsistent results. Has anyone had this similar problem?","categoryID":19,"dateInserted":"2023-06-16T15:18:18+00:00","dateUpdated":null,"dateLastComment":"2023-06-16T15:18:18+00:00","insertUserID":38913,"insertUser":{"userID":38913,"name":"coraparks","url":"https:\/\/community.anaplan.com\/profile\/coraparks","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/38913.jpeg","dateLastActive":"2023-06-16T15:20:07+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":38913,"lastUser":{"userID":38913,"name":"coraparks","url":"https:\/\/community.anaplan.com\/profile\/coraparks","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/38913.jpeg","dateLastActive":"2023-06-16T15:20:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155981\/erlang-c-application","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155981\/erlang-c-application","format":"Rich2","groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155978,"type":"question","name":"What is this error?","excerpt":"Import data into the P3 SKU list from a saved view: Use Build SKU saved view in SYS12 SKU Details module.Verify the source to target mapping before running the import.P3 SKU list is a member of the product hierarchy; assign the appropriate parent data.","categoryID":19,"dateInserted":"2023-06-16T07:42:03+00:00","dateUpdated":null,"dateLastComment":"2023-06-16T12:06:51+00:00","insertUserID":112617,"insertUser":{"userID":112617,"name":"SindhuKK","url":"https:\/\/community.anaplan.com\/profile\/SindhuKK","photoUrl":"https:\/\/w3.vanillicon.com\/v2\/3f6c7c7f371bb93c79feffc56f314f82.svg","dateLastActive":"2023-06-16T11:22:57+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":240,"lastUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":14,"score":null,"hot":3373820334,"url":"https:\/\/community.anaplan.com\/discussion\/155978\/what-is-this-error","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155978\/what-is-this-error","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/W9WS4EXLI5CB\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-16T08:10:35+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155979,"type":"question","name":"Check the booleand based on the list formated line item","excerpt":"Hey team, i emp dimesion and anothe same list formated line item another is boolean . if selcte the the emp 1 at list formated line itemn then i should check the box","categoryID":19,"dateInserted":"2023-06-16T10:05:49+00:00","dateUpdated":null,"dateLastComment":"2023-06-16T10:56:10+00:00","insertUserID":70306,"insertUser":{"userID":70306,"name":"143kishornaidu","url":"https:\/\/community.anaplan.com\/profile\/143kishornaidu","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/70306.png","dateLastActive":"2023-06-16T12:28:48+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":58690,"lastUser":{"userID":58690,"name":"BenjaminNiel","url":"https:\/\/community.anaplan.com\/profile\/BenjaminNiel","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/58690.jpeg","dateLastActive":"2023-06-16T23:57:05+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":19,"score":null,"hot":3373823519,"url":"https:\/\/community.anaplan.com\/discussion\/155979\/check-the-booleand-based-on-the-list-formated-line-item","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155979\/check-the-booleand-based-on-the-list-formated-line-item","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/RBXL8V0FRERV\/capture-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-16T10:56:10+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155973,"type":"question","name":"Summary Method Problem","excerpt":"Hi all I'm having some weird numbers on month over month rate calculation that I did. I tried to use Formula for the summary method but it throws me this error below:- I'm not sure if the issue lies in the formula or the summary method. With calculations like this using PREVIOUS() what is the best summary method to use.","categoryID":19,"dateInserted":"2023-06-15T14:27:04+00:00","dateUpdated":null,"dateLastComment":"2023-06-16T07:12:22+00:00","insertUserID":63266,"insertUser":{"userID":63266,"name":"innocent","url":"https:\/\/community.anaplan.com\/profile\/innocent","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/63266.png","dateLastActive":"2023-06-17T16:16:07+00:00","banned":0,"punished":0,"private":true,"label":""},"updateUserID":null,"lastUserID":63266,"lastUser":{"userID":63266,"name":"innocent","url":"https:\/\/community.anaplan.com\/profile\/innocent","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/63266.png","dateLastActive":"2023-06-17T16:16:07+00:00","banned":0,"punished":0,"private":true,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3373739966,"url":"https:\/\/community.anaplan.com\/discussion\/155973\/summary-method-problem","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155973\/summary-method-problem","format":"Rich2","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/PBZ15ASHX19K\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-16T07:12:33+00:00","dateAnswered":"2023-06-15T15:38:39+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155972,"type":"question","name":"Can I add multiple lines of data to a MAILTO link?","excerpt":"I have several links to create an email for me based on highlighting a line of data and that pushes data from each of the fields into specific places in the body of my email. What about if I select multiple lines of data? Can I add all of those lines? Can I add a saved view of selected data to a MAILTO? Hope you can help…","categoryID":19,"dateInserted":"2023-06-15T12:34:10+00:00","dateUpdated":null,"dateLastComment":"2023-06-15T14:13:10+00:00","insertUserID":22893,"insertUser":{"userID":22893,"name":"pknight@cyt-uk.com","url":"https:\/\/community.anaplan.com\/profile\/pknight%40cyt-uk.com","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22893.png","dateLastActive":"2023-06-15T14:11:21+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":22893,"lastUser":{"userID":22893,"name":"pknight@cyt-uk.com","url":"https:\/\/community.anaplan.com\/profile\/pknight%40cyt-uk.com","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22893.png","dateLastActive":"2023-06-15T14:11:21+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":13,"score":null,"hot":3373672040,"url":"https:\/\/community.anaplan.com\/discussion\/155972\/can-i-add-multiple-lines-of-data-to-a-mailto-link","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155972\/can-i-add-multiple-lines-of-data-to-a-mailto-link","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-15T14:13:10+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155942,"type":"question","name":"Use combined lists ou other parent child relation?","excerpt":"[Context Demand Planning for school books] I have 5 lists: SKU (Book) - e.g:5858595Subject - e.g. MathsSchool Year - e.g 5º GradeType of Subject (Mandatory\/Not Mandatory) Theoretically, each subject has two parents: The type of subject and the school year. Since it is not possible I thought of 2 possible designs: A simple…","categoryID":19,"dateInserted":"2023-06-13T15:22:23+00:00","dateUpdated":null,"dateLastComment":"2023-06-15T12:56:13+00:00","insertUserID":107841,"insertUser":{"userID":107841,"name":"versilva","url":"https:\/\/community.anaplan.com\/profile\/versilva","photoUrl":"https:\/\/we.vanillicon.com\/v2\/ec4eb08056e996127efa47796787ccc8.svg","dateLastActive":"2023-06-15T16:27:10+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4411,"lastUser":{"userID":4411,"name":"anirudh","url":"https:\/\/community.anaplan.com\/profile\/anirudh","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4411.png","dateLastActive":"2023-06-16T16:43:14+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":31,"score":null,"hot":3373505316,"url":"https:\/\/community.anaplan.com\/discussion\/155942\/use-combined-lists-ou-other-parent-child-relation","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155942\/use-combined-lists-ou-other-parent-child-relation","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-15T07:48:01+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155965,"type":"question","name":"Remove Limit for List Reset Index","excerpt":"Hello Everyone, I saw a new update that user can reset the list index and allows users the discretion to reset their lists at any point on the basis the list is empty. But this \"Reset\" option is disabled for me. Can anyone suggest when is this \"Reset\" option is enabled? Many Thanks!","categoryID":19,"dateInserted":"2023-06-15T06:52:57+00:00","dateUpdated":"2023-06-15T06:54:03+00:00","dateLastComment":"2023-06-15T12:06:28+00:00","insertUserID":14285,"insertUser":{"userID":14285,"name":"Swarupa_1","url":"https:\/\/community.anaplan.com\/profile\/Swarupa_1","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14285.svg","dateLastActive":"2023-06-15T12:45:53+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":14285,"lastUserID":14285,"lastUser":{"userID":14285,"name":"Swarupa_1","url":"https:\/\/community.anaplan.com\/profile\/Swarupa_1","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14285.svg","dateLastActive":"2023-06-15T12:45:53+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3373643965,"url":"https:\/\/community.anaplan.com\/discussion\/155965\/remove-limit-for-list-reset-index","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155965\/remove-limit-for-list-reset-index","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/FIR9Q0BGS2FK\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-15T08:50:23+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155969,"type":"question","name":"List Update Notification","excerpt":"Hi all, I was wondering if there is a way to notify the user each time a list is updated. In my case, there is a list named \"cost elements\" whose list items might change; the user checks the boolean of the list items belonging to the subset he is supposed to use. It would be nice to add an alert, maybe a KPI, every time…","categoryID":19,"dateInserted":"2023-06-15T09:04:06+00:00","dateUpdated":"2023-06-15T09:49:35+00:00","dateLastComment":"2023-06-15T11:57:11+00:00","insertUserID":85123,"insertUser":{"userID":85123,"name":"LucaRicci","url":"https:\/\/community.anaplan.com\/profile\/LucaRicci","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/85123.png","dateLastActive":"2023-06-15T13:25:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":85123,"lastUserID":62245,"lastUser":{"userID":62245,"name":"kpasko","url":"https:\/\/community.anaplan.com\/profile\/kpasko","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/1V60TLL61Q8N\/nMCFDOHS3V9EI.jpg","dateLastActive":"2023-06-16T13:33:28+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":23,"score":1,"hot":3373650977,"url":"https:\/\/community.anaplan.com\/discussion\/155969\/list-update-notification","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155969\/list-update-notification","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-15T11:57:11+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155967,"type":"question","name":"DYNAMIC DISPLAY NAME FOR FORECAST MONTHS","excerpt":"Hi, I'm currently working on a project on which each entity needs to input their forecast for the current and the two following months each month. In the input module, in addition to time dimension and the list of the entities, i created a new list with three items : M M+1 M+2 to store the data each month. However on the…","categoryID":19,"dateInserted":"2023-06-15T08:19:56+00:00","dateUpdated":null,"dateLastComment":"2023-06-15T08:57:20+00:00","insertUserID":105567,"insertUser":{"userID":105567,"name":"YassineKhadir","url":"https:\/\/community.anaplan.com\/profile\/YassineKhadir","photoUrl":"https:\/\/wa.vanillicon.com\/v2\/abeb37d2c09238192e84f42f44c013a1.svg","dateLastActive":"2023-06-16T12:04:49+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":29855,"lastUser":{"userID":29855,"name":"pyrypeura","url":"https:\/\/community.anaplan.com\/profile\/pyrypeura","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/QTL29AQOL3AO\/n9J3A3U1AHAFF.jpg","dateLastActive":"2023-06-15T13:34:08+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3373637236,"url":"https:\/\/community.anaplan.com\/discussion\/155967\/dynamic-display-name-for-forecast-months","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155967\/dynamic-display-name-for-forecast-months","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-15T08:57:20+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155947,"type":"question","name":"Not able to run the 'Create' action","excerpt":"There are Create actions in my model, whenever I click on any of 'Create' action, this Run button gets disabled automatically for all Create actions, however I am able to run Import , Export actions of this model. I am Workspace Administrator and have full access to the model. Please suggest if I am missing some access…","categoryID":19,"dateInserted":"2023-06-14T10:42:53+00:00","dateUpdated":null,"dateLastComment":"2023-06-15T08:25:39+00:00","insertUserID":38419,"insertUser":{"userID":38419,"name":"Aniruddha","url":"https:\/\/community.anaplan.com\/profile\/Aniruddha","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/38419.png","dateLastActive":"2023-06-15T11:28:54+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":38419,"lastUser":{"userID":38419,"name":"Aniruddha","url":"https:\/\/community.anaplan.com\/profile\/Aniruddha","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/38419.png","dateLastActive":"2023-06-15T11:28:54+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":31,"score":null,"hot":3373560512,"url":"https:\/\/community.anaplan.com\/discussion\/155947\/not-able-to-run-the-create-action","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155947\/not-able-to-run-the-create-action","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/7XX05O0OUZAC\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-14T12:29:41+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155746,"type":"question","name":"I have created a ranked formula but when I go to sum the total it brings in the sum of all accounts","excerpt":"I am dimensioned across account, time, and practice. My formula looks like this IF Top Account Filter THEN 'Actual + Expected' ELSE 0. It seems to work with out a time dimension.","categoryID":19,"dateInserted":"2023-05-19T21:19:02+00:00","dateUpdated":"2023-05-19T21:19:33+00:00","dateLastComment":"2023-06-15T08:21:36+00:00","insertUserID":70607,"insertUser":{"userID":70607,"name":"Jbrawley","url":"https:\/\/community.anaplan.com\/profile\/Jbrawley","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/70607.jpeg","dateLastActive":"2023-06-16T19:00:48+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":70607,"lastUserID":113709,"lastUser":{"userID":113709,"name":"SWhod19","url":"https:\/\/community.anaplan.com\/profile\/SWhod19","photoUrl":"https:\/\/w5.vanillicon.com\/v2\/5e01b2737afb00d74607c7cef8d28a03.svg","dateLastActive":"2023-06-07T03:49:09+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":41,"score":null,"hot":3371349638,"url":"https:\/\/community.anaplan.com\/discussion\/155746\/i-have-created-a-ranked-formula-but-when-i-go-to-sum-the-total-it-brings-in-the-sum-of-all-accounts","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155746\/i-have-created-a-ranked-formula-but-when-i-go-to-sum-the-total-it-brings-in-the-sum-of-all-accounts","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-22T03:48:42+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155855,"type":"question","name":"Can we assign access to Actions in Production the same as we assign roles to production?","excerpt":"Hi, Not sure if this has been submitted before but I quickly searched and could not find any. Problem: Can we assign access to Actions in Production model? Sometimes, we need to create new actions and we need to assign access to those actions in development model, so when sync to production, the roles can access those…","categoryID":19,"dateInserted":"2023-06-02T00:10:21+00:00","dateUpdated":"2023-06-02T00:12:45+00:00","dateLastComment":"2023-06-15T08:18:58+00:00","insertUserID":21222,"insertUser":{"userID":21222,"name":"jspascual","url":"https:\/\/community.anaplan.com\/profile\/jspascual","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/21222.png","dateLastActive":"2023-06-15T08:23:43+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":21222,"lastUserID":113593,"lastUser":{"userID":113593,"name":"RouradT8","url":"https:\/\/community.anaplan.com\/profile\/RouradT8","photoUrl":"https:\/\/w5.vanillicon.com\/v2\/59b30fd53deafdb6150d730a0a3414e0.svg","dateLastActive":"2023-06-05T07:54:31+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":33,"score":null,"hot":3372483559,"url":"https:\/\/community.anaplan.com\/discussion\/155855\/can-we-assign-access-to-actions-in-production-the-same-as-we-assign-roles-to-production","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155855\/can-we-assign-access-to-actions-in-production-the-same-as-we-assign-roles-to-production","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T11:04:56+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155804,"type":"question","name":"How to add a button that creates a new line item in the GL that has a hierarchal structure","excerpt":"The current button we have in place has us add in a new SUB-GL\/ vendor item to a numbered list. That numbered list uses an OpEx subset that layers in each new vendor into its respective opex area such as adding \"Anaplan 2.1\" under Software subscriptions in the GL. The problem im running into is that this current structure…","categoryID":19,"dateInserted":"2023-05-26T14:56:53+00:00","dateUpdated":"2023-05-30T14:46:51+00:00","dateLastComment":"2023-06-15T08:17:40+00:00","insertUserID":101156,"insertUser":{"userID":101156,"name":"croufail20","url":"https:\/\/community.anaplan.com\/profile\/croufail20","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/101156.png","dateLastActive":"2023-05-30T17:39:24+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":101156,"lastUserID":114391,"lastUser":{"userID":114391,"name":"lauryfriese","url":"https:\/\/community.anaplan.com\/profile\/lauryfriese","photoUrl":"https:\/\/w3.vanillicon.com\/v2\/3731b13581812b8a7004c4deae144eb4.svg","dateLastActive":"2023-06-14T08:54:52+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":42,"score":null,"hot":3371931873,"url":"https:\/\/community.anaplan.com\/discussion\/155804\/how-to-add-a-button-that-creates-a-new-line-item-in-the-gl-that-has-a-hierarchal-structure","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155804\/how-to-add-a-button-that-creates-a-new-line-item-in-the-gl-that-has-a-hierarchal-structure","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/5KQCWWYLF6KS\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-02T19:55:34+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":48,"urlcode":"Model-Builder","name":"Model Builder"},{"tagID":1092,"urlcode":"Model-Contributor","name":"Model Contributor"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155948,"type":"question","name":"Time based IRR Calculation","excerpt":"Hi All, I've list of transactions and data is day wise. I need to calculate IRR on time basis . I want calculate IRR on day basis and at the end the summarized level IRR i.e Quarterly, Yearly. Also I want to calculate Asset wise and fund wise IRR. Can anyone have idea about how to do it? For your reference please find the…","categoryID":19,"dateInserted":"2023-06-14T12:25:54+00:00","dateUpdated":null,"dateLastComment":"2023-06-15T07:53:45+00:00","insertUserID":23168,"insertUser":{"userID":23168,"name":"Ashutosh","url":"https:\/\/community.anaplan.com\/profile\/Ashutosh","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/23168.png","dateLastActive":"2023-06-16T12:32:12+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":23168,"lastUser":{"userID":23168,"name":"Ashutosh","url":"https:\/\/community.anaplan.com\/profile\/Ashutosh","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/23168.png","dateLastActive":"2023-06-16T12:32:12+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3373562379,"url":"https:\/\/community.anaplan.com\/discussion\/155948\/time-based-irr-calculation","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155948\/time-based-irr-calculation","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/RZJVS7LNX0YJ\/rolling-irr-example-116464.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"rolling_IRR_example_116464.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-15T06:02:06+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155946,"type":"question","name":"Summary method - Ration to Sum","excerpt":"Hello community, is there any possibility in anaplan to retrieve data from line item defined on ratio on summary method[As source] to line item with sum in summary method [target]? Any help or suggestion? Thank you","categoryID":19,"dateInserted":"2023-06-14T10:13:15+00:00","dateUpdated":null,"dateLastComment":"2023-06-15T02:32:04+00:00","insertUserID":112327,"insertUser":{"userID":112327,"name":"Sem","url":"https:\/\/community.anaplan.com\/profile\/Sem","photoUrl":"https:\/\/w8.vanillicon.com\/v2\/8f920e894bf389fd88df2ceb01c04628.svg","dateLastActive":"2023-06-15T11:24:26+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":80604,"lastUser":{"userID":80604,"name":"Venki9902","url":"https:\/\/community.anaplan.com\/profile\/Venki9902","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/D83ETBO0T865\/nLLLBBE4TYQ6D.JPG","dateLastActive":"2023-06-17T11:49:57+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":32,"score":null,"hot":3373537519,"url":"https:\/\/community.anaplan.com\/discussion\/155946\/summary-method-ration-to-sum","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155946\/summary-method-ration-to-sum","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-14T10:52:24+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155958,"type":"question","name":"Full access role can't run an action","excerpt":"Hi, a user with the role Full Access needs to be able to run a process, when going to Users then within the Roles—>Action tab I can not see the Full Access Role to provide the access to all actions included in the process. The action brings data from our data hub into the model. Note: I should not provide Workspace…","categoryID":19,"dateInserted":"2023-06-14T21:13:12+00:00","dateUpdated":"2023-06-14T21:19:31+00:00","dateLastComment":"2023-06-14T22:06:47+00:00","insertUserID":93481,"insertUser":{"userID":93481,"name":"JohanSmith","url":"https:\/\/community.anaplan.com\/profile\/JohanSmith","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/93481.png","dateLastActive":"2023-06-16T19:10:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":93481,"lastUserID":240,"lastUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":3373558199,"url":"https:\/\/community.anaplan.com\/discussion\/155958\/full-access-role-cant-run-an-action","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155958\/full-access-role-cant-run-an-action","format":"Rich2","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/T0QDKNA0K24V\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-15T00:29:42+00:00","dateAnswered":"2023-06-14T22:06:47+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155951,"type":"question","name":"How OFFSET operates? Please explain with examples.","excerpt":"","categoryID":19,"dateInserted":"2023-06-14T17:36:15+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T19:06:05+00:00","insertUserID":104547,"insertUser":{"userID":104547,"name":"Rutujakhadilkar","url":"https:\/\/community.anaplan.com\/profile\/Rutujakhadilkar","photoUrl":"https:\/\/w5.vanillicon.com\/v2\/597cda3d4f47f405d503755622634701.svg","dateLastActive":"2023-06-17T05:15:57+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":240,"lastUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":4,"score":null,"hot":3373534340,"url":"https:\/\/community.anaplan.com\/discussion\/155951\/how-offset-operates-please-explain-with-examples","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155951\/how-offset-operates-please-explain-with-examples","format":"Rich2","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-15T04:28:24+00:00","dateAnswered":"2023-06-14T19:06:05+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155950,"type":"question","name":"ISFIRSTOCCURENCE() issue in model when more users are added.","excerpt":"Hi Everyone, I added 1 user into my system and as soon as I run one process, it is failing to say that \"Too many cells for ISFIRSTOCCURENCE calculation: actual =50000094 maximum=50000000\". But as I remove 1 user from the users tab the process starts running fine again. I am a little bit confused about why this kind of…","categoryID":19,"dateInserted":"2023-06-14T12:47:52+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T14:30:24+00:00","insertUserID":50001,"insertUser":{"userID":50001,"name":"PulkitChawla21","url":"https:\/\/community.anaplan.com\/profile\/PulkitChawla21","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/3LDR5IH5TWNM\/nIZ9ECI32HDLR.jpg","dateLastActive":"2023-06-15T18:36:46+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":240,"lastUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-06-16T12:04:14+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":3373500496,"url":"https:\/\/community.anaplan.com\/discussion\/155950\/isfirstoccurence-issue-in-model-when-more-users-are-added","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155950\/isfirstoccurence-issue-in-model-when-more-users-are-added","format":"Rich2","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/UQV2Q421C1Y6\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-15T07:55:45+00:00","dateAnswered":"2023-06-14T14:30:24+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155921,"type":"question","name":"Circular Reference Issue","excerpt":"Hi Anaplan, Is there a workaround on circular reference issue?. I'm doing a calculation on the Profit Line Item which is: But am getting a circular reference when adding the VOD Cost line item in the formula. The VOD Cost line item references also the VOD Revenue line item, which I've screenshot below. Is there a…","categoryID":19,"dateInserted":"2023-06-11T14:36:31+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T07:23:21+00:00","insertUserID":63266,"insertUser":{"userID":63266,"name":"innocent","url":"https:\/\/community.anaplan.com\/profile\/innocent","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/63266.png","dateLastActive":"2023-06-17T16:16:07+00:00","banned":0,"punished":0,"private":true,"label":""},"updateUserID":null,"lastUserID":63266,"lastUser":{"userID":63266,"name":"innocent","url":"https:\/\/community.anaplan.com\/profile\/innocent","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/63266.png","dateLastActive":"2023-06-17T16:16:07+00:00","banned":0,"punished":0,"private":true,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3373223392,"url":"https:\/\/community.anaplan.com\/discussion\/155921\/circular-reference-issue","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155921\/circular-reference-issue","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/TMAZ1BOCVW0P\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-12T04:18:53+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":105786,"type":"question","name":"Performance affect of \"SELECT:\" and \"LOOKUP:\" used together","excerpt":"Hi community! I couldn't find any information on whether it's recommended to split SELECT and LOOKUP for better performance. This thread helped me to understand that SELECT works in a similar way as LOOKUP (thanks to @DavidSmith for insight). So does it mean that SELECT and LOOKUP can be used together, unlike SELECT and…","categoryID":19,"dateInserted":"2021-04-21T02:58:34+00:00","dateUpdated":null,"dateLastComment":"2023-06-13T19:25:01+00:00","insertUserID":9870,"insertUser":{"userID":9870,"name":"Hayk","url":"https:\/\/community.anaplan.com\/profile\/Hayk","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9870.jpeg","dateLastActive":"2023-06-13T08:37:25+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":37641,"lastUser":{"userID":37641,"name":"Olek P","url":"https:\/\/community.anaplan.com\/profile\/Olek%20P","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/37641.jpeg","dateLastActive":"2023-06-14T16:18:56+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":275,"score":null,"hot":3305661215,"url":"https:\/\/community.anaplan.com\/discussion\/105786\/performance-affect-of-select-and-lookup-used-together","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/105786\/performance-affect-of-select-and-lookup-used-together","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-21T03:49:54+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155925,"type":"question","name":"How to calculate response target time and Resolution target time","excerpt":"Hello, I'm trying to calculate the Reponse target time and Resolution target time for a request by the end user. In that module I already have: Creation date, format Date → the day when end user will raise the request → will be filled manually Creation hour, format number → the time when end user will raise the request →→…","categoryID":19,"dateInserted":"2023-06-12T09:32:10+00:00","dateUpdated":null,"dateLastComment":"2023-06-13T09:45:13+00:00","insertUserID":92178,"insertUser":{"userID":92178,"name":"fpopa","url":"https:\/\/community.anaplan.com\/profile\/fpopa","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/92178.png","dateLastActive":"2023-06-16T09:21:07+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":89995,"lastUser":{"userID":89995,"name":"rishi8118","url":"https:\/\/community.anaplan.com\/profile\/rishi8118","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/89995.png","dateLastActive":"2023-06-16T08:38:04+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":3373213043,"url":"https:\/\/community.anaplan.com\/discussion\/155925\/how-to-calculate-response-target-time-and-resolution-target-time","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155925\/how-to-calculate-response-target-time-and-resolution-target-time","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-13T07:22:19+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155934,"type":"question","name":"MAPPING","excerpt":"I have a module with dimension x and I want to get a line item y from another module with dimension z . How can I achieve this in anaplan? I am unable to use direct lookup modules","categoryID":19,"dateInserted":"2023-06-13T07:10:24+00:00","dateUpdated":"2023-06-13T07:12:13+00:00","dateLastComment":"2023-06-13T07:36:28+00:00","insertUserID":39080,"insertUser":{"userID":39080,"name":"Ankitabhardwaj","url":"https:\/\/community.anaplan.com\/profile\/Ankitabhardwaj","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/39080.png","dateLastActive":"2023-06-15T13:23:45+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":39080,"lastUserID":91665,"lastUser":{"userID":91665,"name":"AkhilEmmanual","url":"https:\/\/community.anaplan.com\/profile\/AkhilEmmanual","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/LBZINBMUGD35\/n3KYKRYIUA3HB.png","dateLastActive":"2023-06-17T17:52:41+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3373282612,"url":"https:\/\/community.anaplan.com\/discussion\/155934\/mapping","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155934\/mapping","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-13T07:36:28+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155933,"type":"question","name":"Activity: Prepare Data Exports","excerpt":"Hello, I'm not sure why the shipping cost line item is showing 0. Below are the instructions followed and formula used in the module: INV01 Inventory Ordering reference: Thank you so much in advance!","categoryID":19,"dateInserted":"2023-06-12T22:40:27+00:00","dateUpdated":null,"dateLastComment":"2023-06-13T04:10:49+00:00","insertUserID":101792,"insertUser":{"userID":101792,"name":"JeemarieB","url":"https:\/\/community.anaplan.com\/profile\/JeemarieB","photoUrl":"https:\/\/w9.vanillicon.com\/v2\/9592cca92d25b46ebc7029c1d8571ff4.svg","dateLastActive":"2023-06-14T17:45:28+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":91665,"lastUser":{"userID":91665,"name":"AkhilEmmanual","url":"https:\/\/community.anaplan.com\/profile\/AkhilEmmanual","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/LBZINBMUGD35\/n3KYKRYIUA3HB.png","dateLastActive":"2023-06-17T17:52:41+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3373239676,"url":"https:\/\/community.anaplan.com\/discussion\/155933\/activity-prepare-data-exports","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155933\/activity-prepare-data-exports","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/TIWWC8ZZYGV4\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-13T04:10:49+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":35206,"type":"question","name":"Does Anaplan allow different formula for each versions?","excerpt":"Hi! For example I have 4 versions namely: Actual, Budget, Forecast 1 and Forecast 2. Does Anaplan allow different formula for each version I have in my module? Say, Actual version will have a different and unique formula with Budget, etc for the same modul. Thanks for any help! ","categoryID":19,"dateInserted":"2018-08-05T23:21:31+00:00","dateUpdated":null,"dateLastComment":"2023-06-12T14:51:07+00:00","insertUserID":11927,"insertUser":{"userID":11927,"name":"jsdeguzman","url":"https:\/\/community.anaplan.com\/profile\/jsdeguzman","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/11927.png","dateLastActive":"2018-12-04T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":2299,"lastUser":{"userID":2299,"name":"PaulRitner","url":"https:\/\/community.anaplan.com\/profile\/PaulRitner","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/2299.jpeg","dateLastActive":"2023-06-16T19:22:16+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":83,"score":null,"hot":3220096358,"url":"https:\/\/community.anaplan.com\/discussion\/35206\/does-anaplan-allow-different-formula-for-each-versions","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/35206\/does-anaplan-allow-different-formula-for-each-versions","format":"html","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-23T21:29:03+00:00","dateAnswered":"2018-08-06T06:35:47+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155920,"type":"question","name":"Anaplan Percentage Format Issue","excerpt":"Hi All, I am trying to calculate the Compound annual growth rate (CAGR) in Anaplan and I am getting a 100% instead of 1%. Here is the formula logic in excel =((Z84\/C84)^(1\/23)-1) The first value is cell=(C84) January 2021 value = -167,217 The last value is cell=(Z84) December 2022 value = -136,485 The Cost values go across…","categoryID":19,"dateInserted":"2023-06-11T13:27:20+00:00","dateUpdated":null,"dateLastComment":"2023-06-12T11:26:45+00:00","insertUserID":63266,"insertUser":{"userID":63266,"name":"innocent","url":"https:\/\/community.anaplan.com\/profile\/innocent","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/63266.png","dateLastActive":"2023-06-17T16:16:07+00:00","banned":0,"punished":0,"private":true,"label":""},"updateUserID":null,"lastUserID":23479,"lastUser":{"userID":23479,"name":"Puneeth H P","url":"https:\/\/community.anaplan.com\/profile\/Puneeth%20H%20P","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/23479.jpeg","dateLastActive":"2023-06-16T05:13:32+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":3373060445,"url":"https:\/\/community.anaplan.com\/discussion\/155920\/anaplan-percentage-format-issue","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155920\/anaplan-percentage-format-issue","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/AEEJBADO1177\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-12T11:26:00+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155830,"type":"question","name":"HiI want to use quarterly sum in another module which is in months. How to do that?","excerpt":"","categoryID":19,"dateInserted":"2023-05-31T15:13:21+00:00","dateUpdated":"2023-06-01T08:30:39+00:00","dateLastComment":"2023-06-11T18:48:16+00:00","insertUserID":94216,"insertUser":{"userID":94216,"name":"Chandrashekar1997","url":"https:\/\/community.anaplan.com\/profile\/Chandrashekar1997","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/94216.png","dateLastActive":"2023-06-07T17:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":94216,"lastUserID":113867,"lastUser":{"userID":113867,"name":"Krishnarao","title":"Anaplan model builder","url":"https:\/\/community.anaplan.com\/profile\/Krishnarao","photoUrl":"https:\/\/wb.vanillicon.com\/v2\/bcb942a25af0174a67322f7186e9be6e.svg","dateLastActive":"2023-06-13T13:11:23+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":61,"score":null,"hot":3372057697,"url":"https:\/\/community.anaplan.com\/discussion\/155830\/hii-want-to-use-quarterly-sum-in-another-module-which-is-in-months-how-to-do-that","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155830\/hii-want-to-use-quarterly-sum-in-another-module-which-is-in-months-how-to-do-that","format":"Rich2","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-01T08:29:25+00:00","dateAnswered":"2023-05-31T15:50:50+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":79781,"type":"question","name":"Level 3 Sprint 1 3.2 Model Build Specifications","excerpt":"Should I be creating a separate module for the Volume Growth rates by country and then using a lookup to pull in the requisite %'s into the TRA01 module?","categoryID":19,"dateInserted":"2020-08-10T05:21:36+00:00","dateUpdated":null,"dateLastComment":"2023-06-11T04:30:33+00:00","insertUserID":34774,"insertUser":{"userID":34774,"name":"bleeds","url":"https:\/\/community.anaplan.com\/profile\/bleeds","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/34774.png","dateLastActive":"2020-10-26T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":60707,"lastUser":{"userID":60707,"name":"RyanD","url":"https:\/\/community.anaplan.com\/profile\/RyanD","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/60707.png","dateLastActive":"2023-06-14T03:50:18+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":1,"hot":3283496829,"url":"https:\/\/community.anaplan.com\/discussion\/79781\/level-3-sprint-1-3-2-model-build-specifications","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/79781\/level-3-sprint-1-3-2-model-build-specifications","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-10-25T16:17:08+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">