连接是社区的心跳，使成员围绕共同的主题保持一致。在这里，您将找到将现实生活体验带到最前沿的问题和解决方案，从而使整个生态系统受益。加入对话-正在发生!
plan平台讨论
类别列表
社区是与你的同伴联系和互动的地方。
看看现在正在发生的最新对话!
🚀 Newest questions<\/h2> <\/div>\n \n- \nSUM IF Anaplan<\/a>\n
hi there, I would like to build a report which would basically be a P&L where I display the cost per segment in 1 table. My segments being a grouping of a list (departments): my "base" P&L looks like that: and the report I would like to build should look like that: The idea would be to fill in the cost lines (Human…<\/p>\n<\/li>\n
- \nDefine current year end week<\/a>\n
Hi all, How can i define CY end week by formula not hardcode. we dont want to use CY week +52 so any Suggestions<\/p>\n<\/li>\n
- \n2.3.9.1 Import data into DAT03 Historic Volumes module<\/a>\n
please any one help to solve this activity .I n mapping i am not getting P3 SKU values so data is not importing<\/p>\n<\/li>\n
- \nHad L2S3 erased and then recovered now issue with all inventory numbers showing 0<\/a>\n
All models were erased but Anaplan recovered them, but now all my L2S3 that deal with inventory, beginning, reorder, forecast etc, in my Supply Chain models are zeroed out. I have the numbers in my Data Hub models but can't seem to move them to the Supply Chain models. Any Suggestions? Thanks, MPW<\/p>\n<\/li>\n
- \nGet Maximum number against year in a transaction data?<\/a>\n
Hi, I have transaction data where i have a period formatted line item with the year and a number formatted line item called Number. I want the maximum number against each year in the Max column. I tried the Number[MAX:Year] but it didn't work. So how can I get the maximum number against each Year? Attaching the screnshot…<\/p>\n<\/li>\n
- \n3.4.3 Activity: Create Country Summary Module<\/a>\n
I have created the module as requested and added below formula, however there is no data reflecting in my INV02. Can anyone suggest where i am going wrong? SYS08 module snip INV02 module formula INV01 snip where my stockcount is shown as 0 completely. INV02 is shown as 0, not sure of error. Kindly let me know, thanks for…<\/p>\n<\/li>\n
- \nMoving Average Issue<\/a>\n
Hi, For my Forecast Jan 2023 I want to bring the (Actuals) AVERAGE of Jan 2021 and Jan 2022. And for my Feb 2023 I want the AVERAGE of Feb 2021 and Feb 2022, e.t.c. To achieve this I split the line item actuals values into the ones below, for calculation and then bring it to the forecast. for 2021 Values line item for 2022…<\/p>\n<\/li>\n
- \nTraining procedure<\/a>\n
I m confused to understand the method of training as till now portal is only updated with written content . Will we get video session or this is only content with which we have to move on .<\/p>\n<\/li>\n
- \nHow to filter elements of a Line Item subset by user<\/a>\n
We can filter elements in a list, We can filter Time elements, We can filter Line Items using a Line Item Subset, But can we filter items in a Line Item subset? (All dynamically by a user) Summary of the problem: I use a boolean per user to filter a module sized by a line item subset. The filter worked fine until last…<\/p>\n<\/li>\n
- \ncalculate time settings with out hard coding<\/a>\n
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<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"🚀 Newest questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","sort":"-dateInserted","limit":10,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":155895,"type":"question","name":"SUM IF Anaplan","excerpt":"hi there, I would like to build a report which would basically be a P&L where I display the cost per segment in 1 table. My segments being a grouping of a list (departments): my \"base\" P&L looks like that: and the report I would like to build should look like that: The idea would be to fill in the cost lines (Human…","categoryID":19,"dateInserted":"2023-06-07T07:53:24+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T07:53:24+00:00","insertUserID":60693,"insertUser":{"userID":60693,"name":"HugoManchon","url":"https:\/\/community.anaplan.com\/profile\/HugoManchon","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/60693.png","dateLastActive":"2023-06-07T08:04:58+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/general+contributor.png\")
"},"updateUserID":null,"lastUserID":60693,"lastUser":{"userID":60693,"name":"HugoManchon","url":"https:\/\/community.anaplan.com\/profile\/HugoManchon","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/60693.png","dateLastActive":"2023-06-07T08:04:58+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":8,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155895\/sum-if-anaplan","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155895\/sum-if-anaplan","format":"Rich2","lastPost":{"discussionID":155895,"name":"SUM IF Anaplan","url":"https:\/\/community.anaplan.com\/discussion\/155895\/sum-if-anaplan","dateInserted":"2023-06-07T07:53:24+00:00","insertUserID":60693,"insertUser":{"userID":60693,"name":"HugoManchon","url":"https:\/\/community.anaplan.com\/profile\/HugoManchon","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/60693.png","dateLastActive":"2023-06-07T08:04:58+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/U4BBMSNJVDTR\/screenshot-2023-06-07-094421.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-07 094421.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155894,"type":"question","name":"Define current year end week","excerpt":"Hi all, How can i define CY end week by formula not hardcode. we dont want to use CY week +52 so any Suggestions","categoryID":19,"dateInserted":"2023-06-07T06:10:16+00:00","dateUpdated":"2023-06-07T06:10:37+00:00","dateLastComment":"2023-06-07T06:10:16+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-07T08:08:10+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/new+contributor.png\")
"},"updateUserID":70306,"lastUserID":70306,"lastUser":{"userID":70306,"name":"143kishornaidu","url":"https:\/\/community.anaplan.com\/profile\/143kishornaidu","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/70306.png","dateLastActive":"2023-06-07T08:08:10+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":10,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155894\/define-current-year-end-week","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155894\/define-current-year-end-week","format":"Rich2","lastPost":{"discussionID":155894,"name":"Define current year end week","url":"https:\/\/community.anaplan.com\/discussion\/155894\/define-current-year-end-week","dateInserted":"2023-06-07T06:10:16+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-07T08:08:10+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/B1ONMQP8DFZ2\/capture-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155893,"type":"question","name":"2.3.9.1 Import data into DAT03 Historic Volumes module","excerpt":"please any one help to solve this activity .I n mapping i am not getting P3 SKU values so data is not importing","categoryID":182,"dateInserted":"2023-06-07T05:14:18+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T06:25:28+00:00","insertUserID":110617,"insertUser":{"userID":110617,"name":"learnerghi","url":"https:\/\/community.anaplan.com\/profile\/learnerghi","photoUrl":"https:\/\/wa.vanillicon.com\/v2\/a4831da83c8b86470ac69f93157d1ceb.svg","dateLastActive":"2023-06-07T05:57:42+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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/respected+contributor.png\")
"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":14,"score":null,"hot":3372235786,"url":"https:\/\/community.anaplan.com\/discussion\/155893\/2-3-9-1-import-data-into-dat03-historic-volumes-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155893\/2-3-9-1-import-data-into-dat03-historic-volumes-module","format":"Rich2","lastPost":{"discussionID":155893,"commentID":158413,"name":"Re: 2.3.9.1 Import data into DAT03 Historic Volumes module","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158413#Comment_158413","dateInserted":"2023-06-07T06:25:28+00:00","insertUserID":91665,"insertUser":{"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/5LB76ATLXD6W\/activity.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"activity.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T05:44:18+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155889,"type":"question","name":"Had L2S3 erased and then recovered now issue with all inventory numbers showing 0","excerpt":"All models were erased but Anaplan recovered them, but now all my L2S3 that deal with inventory, beginning, reorder, forecast etc, in my Supply Chain models are zeroed out. I have the numbers in my Data Hub models but can't seem to move them to the Supply Chain models. Any Suggestions? Thanks, MPW","categoryID":182,"dateInserted":"2023-06-06T20:51:08+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T05:27:00+00:00","insertUserID":106365,"insertUser":{"userID":106365,"name":"MPWall","url":"https:\/\/community.anaplan.com\/profile\/MPWall","photoUrl":"https:\/\/w0.vanillicon.com\/v2\/018d544ff2d200048ec344776786396c.svg","dateLastActive":"2023-06-06T21:46:45+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":64108,"lastUser":{"userID":64108,"name":"krishnadbr","url":"https:\/\/community.anaplan.com\/profile\/krishnadbr","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/64108.png","dateLastActive":"2023-06-07T07:22:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3372200888,"url":"https:\/\/community.anaplan.com\/discussion\/155889\/had-l2s3-erased-and-then-recovered-now-issue-with-all-inventory-numbers-showing-0","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155889\/had-l2s3-erased-and-then-recovered-now-issue-with-all-inventory-numbers-showing-0","format":"Rich2","lastPost":{"discussionID":155889,"commentID":158409,"name":"Re: Had L2S3 erased and then recovered now issue with all inventory numbers showing 0","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158409#Comment_158409","dateInserted":"2023-06-07T05:27:00+00:00","insertUserID":64108,"insertUser":{"userID":64108,"name":"krishnadbr","url":"https:\/\/community.anaplan.com\/profile\/krishnadbr","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/64108.png","dateLastActive":"2023-06-07T07:22:07+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T05:27:00+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155888,"type":"question","name":"Get Maximum number against year in a transaction data?","excerpt":"Hi, I have transaction data where i have a period formatted line item with the year and a number formatted line item called Number. I want the maximum number against each year in the Max column. I tried the Number[MAX:Year] but it didn't work. So how can I get the maximum number against each Year? Attaching the screnshot…","categoryID":19,"dateInserted":"2023-06-06T20:50:54+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T21:12:36+00:00","insertUserID":28464,"insertUser":{"userID":28464,"name":"Arnab116","url":"https:\/\/community.anaplan.com\/profile\/Arnab116","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28464.svg","dateLastActive":"2023-06-06T21:13:49+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/community+boss.png\")
"},"updateUserID":null,"lastUserID":28464,"lastUser":{"userID":28464,"name":"Arnab116","url":"https:\/\/community.anaplan.com\/profile\/Arnab116","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28464.svg","dateLastActive":"2023-06-06T21:13:49+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3372171810,"url":"https:\/\/community.anaplan.com\/discussion\/155888\/get-maximum-number-against-year-in-a-transaction-data","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155888\/get-maximum-number-against-year-in-a-transaction-data","format":"Rich2","lastPost":{"discussionID":155888,"commentID":158402,"name":"Re: Get Maximum number against year in a transaction data?","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158402#Comment_158402","dateInserted":"2023-06-06T21:12:36+00:00","insertUserID":28464,"insertUser":{"userID":28464,"name":"Arnab116","url":"https:\/\/community.anaplan.com\/profile\/Arnab116","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28464.svg","dateLastActive":"2023-06-06T21:13:49+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/4ARW1IFE1BBM\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-06T21:12:11+00:00","dateAnswered":"2023-06-06T21:06:51+00:00","acceptedAnswers":[{"commentID":158401,"body":"
@Arnab116<\/a> <\/p>In another module dimensionalized by your Year (the members in Year Format), try this formula<\/p>
Above Module Name.Number[MAX: Year Format]<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155887,"type":"question","name":"3.4.3 Activity: Create Country Summary Module","excerpt":"I have created the module as requested and added below formula, however there is no data reflecting in my INV02. Can anyone suggest where i am going wrong? SYS08 module snip INV02 module formula INV01 snip where my stockcount is shown as 0 completely. INV02 is shown as 0, not sure of error. Kindly let me know, thanks for…","categoryID":19,"dateInserted":"2023-06-06T19:41:23+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T03:27:57+00:00","insertUserID":111534,"insertUser":{"userID":111534,"name":"Smuti","url":"https:\/\/community.anaplan.com\/profile\/Smuti","photoUrl":"https:\/\/w9.vanillicon.com\/v2\/9d5dc2e4b24f8bebc0fc5d8301624714.svg","dateLastActive":"2023-06-06T19:56:12+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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":3372189560,"url":"https:\/\/community.anaplan.com\/discussion\/155887\/3-4-3-activity-create-country-summary-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155887\/3-4-3-activity-create-country-summary-module","format":"Rich2","lastPost":{"discussionID":155887,"commentID":158407,"name":"Re: 3.4.3 Activity: Create Country Summary Module","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158407#Comment_158407","dateInserted":"2023-06-07T03:27:57+00:00","insertUserID":91665,"insertUser":{"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/Q7J68MPDUXXS\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T03:27:57+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155886,"type":"question","name":"Moving Average Issue","excerpt":"Hi, For my Forecast Jan 2023 I want to bring the (Actuals) AVERAGE of Jan 2021 and Jan 2022. And for my Feb 2023 I want the AVERAGE of Feb 2021 and Feb 2022, e.t.c. To achieve this I split the line item actuals values into the ones below, for calculation and then bring it to the forecast. for 2021 Values line item for 2022…","categoryID":19,"dateInserted":"2023-06-06T18:36:26+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T05:38:36+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-07T06:36:51+00:00","banned":0,"punished":0,"private":true,"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3372193502,"url":"https:\/\/community.anaplan.com\/discussion\/155886\/moving-average-issue","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155886\/moving-average-issue","format":"Rich2","lastPost":{"discussionID":155886,"commentID":158410,"name":"Re: Moving Average Issue","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158410#Comment_158410","dateInserted":"2023-06-07T05:38:36+00:00","insertUserID":91665,"insertUser":{"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/VIE29P89I03Z\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T05:38:36+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155885,"type":"question","name":"Training procedure","excerpt":"I m confused to understand the method of training as till now portal is only updated with written content . Will we get video session or this is only content with which we have to move on .","categoryID":182,"dateInserted":"2023-06-06T16:05:28+00:00","dateUpdated":"2023-06-06T16:06:21+00:00","dateLastComment":"2023-06-06T22:09:33+00:00","insertUserID":113205,"insertUser":{"userID":113205,"name":"VK3105","url":"https:\/\/community.anaplan.com\/profile\/VK3105","photoUrl":"https:\/\/w7.vanillicon.com\/v2\/70b349ddec0ade7760b0fc937ece652a.svg","dateLastActive":"2023-06-06T16:18:42+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/new+member.png\")
"},"updateUserID":113205,"lastUserID":8014,"lastUser":{"userID":8014,"name":"Tiffany.Rice","url":"https:\/\/community.anaplan.com\/profile\/Tiffany.Rice","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8014.png","dateLastActive":"2023-06-06T22:07:01+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/CMA.png\")
"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3372157501,"url":"https:\/\/community.anaplan.com\/discussion\/155885\/training-procedure","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155885\/training-procedure","format":"Rich2","lastPost":{"discussionID":155885,"commentID":158404,"name":"Re: Training procedure","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158404#Comment_158404","dateInserted":"2023-06-06T22:09:33+00:00","insertUserID":8014,"insertUser":{"userID":8014,"name":"Tiffany.Rice","url":"https:\/\/community.anaplan.com\/profile\/Tiffany.Rice","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8014.png","dateLastActive":"2023-06-06T22:07:01+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-06T22:09:33+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155884,"type":"question","name":"How to filter elements of a Line Item subset by user","excerpt":"We can filter elements in a list, We can filter Time elements, We can filter Line Items using a Line Item Subset, But can we filter items in a Line Item subset? (All dynamically by a user) Summary of the problem: I use a boolean per user to filter a module sized by a line item subset. The filter worked fine until last…","categoryID":18,"dateInserted":"2023-06-06T14:54:51+00:00","dateUpdated":"2023-06-06T15:00:09+00:00","dateLastComment":"2023-06-06T14:54:51+00:00","insertUserID":14875,"insertUser":{"userID":14875,"name":"axel.frot","url":"https:\/\/community.anaplan.com\/profile\/axel.frot","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14875.png","dateLastActive":"2023-06-07T06:51:13+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":14875,"lastUserID":14875,"lastUser":{"userID":14875,"name":"axel.frot","url":"https:\/\/community.anaplan.com\/profile\/axel.frot","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14875.png","dateLastActive":"2023-06-07T06:51:13+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":18,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155884\/how-to-filter-elements-of-a-line-item-subset-by-user","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155884\/how-to-filter-elements-of-a-line-item-subset-by-user","format":"Rich2","lastPost":{"discussionID":155884,"name":"How to filter elements of a Line Item subset by user","url":"https:\/\/community.anaplan.com\/discussion\/155884\/how-to-filter-elements-of-a-line-item-subset-by-user","dateInserted":"2023-06-06T14:54:51+00:00","insertUserID":14875,"insertUser":{"userID":14875,"name":"axel.frot","url":"https:\/\/community.anaplan.com\/profile\/axel.frot","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14875.png","dateLastActive":"2023-06-07T06:51:13+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"User Experience","url":"https:\/\/community.anaplan.com\/categories\/user-experience-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/JYEWMXTZPTKX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":18,"name":"User Experience","url":"https:\/\/community.anaplan.com\/categories\/user-experience-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"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-06T08:06:03+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-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":78982,"lastUser":{"userID":78982,"name":"kishoreanimi","url":"https:\/\/community.anaplan.com\/profile\/kishoreanimi","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/78982.png","dateLastActive":"2023-06-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":20,"score":null,"hot":0,"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","lastPost":{"discussionID":155882,"name":"calculate time settings with out hard coding","url":"https:\/\/community.anaplan.com\/discussion\/155882\/calculate-time-settings-with-out-hard-coding","dateInserted":"2023-06-06T08:06:03+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-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"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":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"$seoContent":"
\n \n ❓ Unanswered questions<\/h2> <\/div>\n \n- \nSUM IF Anaplan<\/a>\n
hi there, I would like to build a report which would basically be a P&L where I display the cost per segment in 1 table. My segments being a grouping of a list (departments): my "base" P&L looks like that: and the report I would like to build should look like that: The idea would be to fill in the cost lines (Human…<\/p>\n<\/li>\n
- \nDefine current year end week<\/a>\n
Hi all, How can i define CY end week by formula not hardcode. we dont want to use CY week +52 so any Suggestions<\/p>\n<\/li>\n
- \nHow to filter elements of a Line Item subset by user<\/a>\n
We can filter elements in a list, We can filter Time elements, We can filter Line Items using a Line Item Subset, But can we filter items in a Line Item subset? (All dynamically by a user) Summary of the problem: I use a boolean per user to filter a module sized by a line item subset. The filter worked fine until last…<\/p>\n<\/li>\n
- \ncalculate time settings with out hard coding<\/a>\n
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<\/p>\n<\/li>\n
- \nStoreOpinion-Can.Com<\/a>\n
Loblaws is a great retail store in Canada. It provides a survey named StoreOpinion, in the part of the survey Loblaws announced a great reward for the survey winners. By participating in the Loblaws official survey at StoreOpinion.CA get a chance to win a $1000 Optimum PC gift card.<\/p>\n<\/li>\n
- \nHelp on P&L What-If Optimizer<\/a>\n
Hi Everyone, I'm trying to build a Simple Optimizer for P&L where Variables are Volume, Selling Price, Cost Price and Objective is to get a Particular Net Income. I'm getting errors and unable to move forward<\/p>\n<\/li>\n
- \nHow to calculate intercompany ownership% calculation for a group companies?<\/a>\n
Problem Statement: I have a requirement where I have to calculate the indirect ownership% of the entities based on the input of direct ownership% Example: The direct ownership% of the entities 'Entity 1' is the ultimate parent'Entity 2' is held by 'Entity 1' by 50%'Entity 3' is held by 'Entity 1' by 100%'Entity 4' is held…<\/p>\n<\/li>\n
- \nLevel 2<\/a>\n
Hi,<\/p>\n<\/li>\n
- \nTableau to Anaplan integration<\/a>\n
Hi team, Could you please help me with best possible way to export data from Tableau and load it in Anaplan by writing script or something. Regards, Venkatesh<\/p>\n<\/li>\n
- \nLevel 3 - Ask the Stakeholders - Designating Sales Reps to Accounts Process Questions<\/a>\n
Level 3 - Ask the Stakeholders Designating Sales Reps to Accounts Process QuestionsThis forum is for asking the stakeholders of the Unicorn Candy Company questions about the Designating Sales Reps to Accounts Process. The Anaplan Academy team will be monitoring this forum during US Central standard business hours. Please…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"❓ Unanswered questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","status":"unanswered","sort":"-dateLastComment","limit":10,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":155895,"type":"question","name":"SUM IF Anaplan","excerpt":"hi there, I would like to build a report which would basically be a P&L where I display the cost per segment in 1 table. My segments being a grouping of a list (departments): my \"base\" P&L looks like that: and the report I would like to build should look like that: The idea would be to fill in the cost lines (Human…","categoryID":19,"dateInserted":"2023-06-07T07:53:24+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T07:53:24+00:00","insertUserID":60693,"insertUser":{"userID":60693,"name":"HugoManchon","url":"https:\/\/community.anaplan.com\/profile\/HugoManchon","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/60693.png","dateLastActive":"2023-06-07T08:04:58+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":60693,"lastUser":{"userID":60693,"name":"HugoManchon","url":"https:\/\/community.anaplan.com\/profile\/HugoManchon","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/60693.png","dateLastActive":"2023-06-07T08:04:58+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":8,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155895\/sum-if-anaplan","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155895\/sum-if-anaplan","format":"Rich2","lastPost":{"discussionID":155895,"name":"SUM IF Anaplan","url":"https:\/\/community.anaplan.com\/discussion\/155895\/sum-if-anaplan","dateInserted":"2023-06-07T07:53:24+00:00","insertUserID":60693,"insertUser":{"userID":60693,"name":"HugoManchon","url":"https:\/\/community.anaplan.com\/profile\/HugoManchon","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/60693.png","dateLastActive":"2023-06-07T08:04:58+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/U4BBMSNJVDTR\/screenshot-2023-06-07-094421.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-07 094421.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155894,"type":"question","name":"Define current year end week","excerpt":"Hi all, How can i define CY end week by formula not hardcode. we dont want to use CY week +52 so any Suggestions","categoryID":19,"dateInserted":"2023-06-07T06:10:16+00:00","dateUpdated":"2023-06-07T06:10:37+00:00","dateLastComment":"2023-06-07T06:10:16+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-07T08:08:10+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":70306,"lastUserID":70306,"lastUser":{"userID":70306,"name":"143kishornaidu","url":"https:\/\/community.anaplan.com\/profile\/143kishornaidu","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/70306.png","dateLastActive":"2023-06-07T08:08:10+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":10,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155894\/define-current-year-end-week","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155894\/define-current-year-end-week","format":"Rich2","lastPost":{"discussionID":155894,"name":"Define current year end week","url":"https:\/\/community.anaplan.com\/discussion\/155894\/define-current-year-end-week","dateInserted":"2023-06-07T06:10:16+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-07T08:08:10+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/B1ONMQP8DFZ2\/capture-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155884,"type":"question","name":"How to filter elements of a Line Item subset by user","excerpt":"We can filter elements in a list, We can filter Time elements, We can filter Line Items using a Line Item Subset, But can we filter items in a Line Item subset? (All dynamically by a user) Summary of the problem: I use a boolean per user to filter a module sized by a line item subset. The filter worked fine until last…","categoryID":18,"dateInserted":"2023-06-06T14:54:51+00:00","dateUpdated":"2023-06-06T15:00:09+00:00","dateLastComment":"2023-06-06T14:54:51+00:00","insertUserID":14875,"insertUser":{"userID":14875,"name":"axel.frot","url":"https:\/\/community.anaplan.com\/profile\/axel.frot","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14875.png","dateLastActive":"2023-06-07T06:51:13+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":14875,"lastUserID":14875,"lastUser":{"userID":14875,"name":"axel.frot","url":"https:\/\/community.anaplan.com\/profile\/axel.frot","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14875.png","dateLastActive":"2023-06-07T06:51:13+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":18,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155884\/how-to-filter-elements-of-a-line-item-subset-by-user","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155884\/how-to-filter-elements-of-a-line-item-subset-by-user","format":"Rich2","lastPost":{"discussionID":155884,"name":"How to filter elements of a Line Item subset by user","url":"https:\/\/community.anaplan.com\/discussion\/155884\/how-to-filter-elements-of-a-line-item-subset-by-user","dateInserted":"2023-06-06T14:54:51+00:00","insertUserID":14875,"insertUser":{"userID":14875,"name":"axel.frot","url":"https:\/\/community.anaplan.com\/profile\/axel.frot","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14875.png","dateLastActive":"2023-06-07T06:51:13+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"User Experience","url":"https:\/\/community.anaplan.com\/categories\/user-experience-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/JYEWMXTZPTKX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":18,"name":"User Experience","url":"https:\/\/community.anaplan.com\/categories\/user-experience-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"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-06T08:06:03+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-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":78982,"lastUser":{"userID":78982,"name":"kishoreanimi","url":"https:\/\/community.anaplan.com\/profile\/kishoreanimi","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/78982.png","dateLastActive":"2023-06-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":20,"score":null,"hot":0,"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","lastPost":{"discussionID":155882,"name":"calculate time settings with out hard coding","url":"https:\/\/community.anaplan.com\/discussion\/155882\/calculate-time-settings-with-out-hard-coding","dateInserted":"2023-06-06T08:06:03+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-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"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":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155868,"type":"question","name":"StoreOpinion-Can.Com","excerpt":"Loblaws is a great retail store in Canada. It provides a survey named StoreOpinion, in the part of the survey Loblaws announced a great reward for the survey winners. By participating in the Loblaws official survey at StoreOpinion.CA get a chance to win a $1000 Optimum PC gift card.","categoryID":182,"dateInserted":"2023-06-04T10:10:14+00:00","dateUpdated":null,"dateLastComment":"2023-06-04T10:10:14+00:00","insertUserID":113545,"insertUser":{"userID":113545,"name":"StoreOpinionCan","title":"StoreOpinion-Can.Com","url":"https:\/\/community.anaplan.com\/profile\/StoreOpinionCan","photoUrl":"https:\/\/w4.vanillicon.com\/v2\/4eeee809f7617daf247d69ad72276c3c.svg","dateLastActive":"2023-06-04T10:07:09+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":113545,"lastUser":{"userID":113545,"name":"StoreOpinionCan","title":"StoreOpinion-Can.Com","url":"https:\/\/community.anaplan.com\/profile\/StoreOpinionCan","photoUrl":"https:\/\/w4.vanillicon.com\/v2\/4eeee809f7617daf247d69ad72276c3c.svg","dateLastActive":"2023-06-04T10:07:09+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":24,"score":-2,"hot":1685872814,"url":"https:\/\/community.anaplan.com\/discussion\/155868\/storeopinion-can-com","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155868\/storeopinion-can-com","format":"Rich2","lastPost":{"discussionID":155868,"name":"StoreOpinion-Can.Com","url":"https:\/\/community.anaplan.com\/discussion\/155868\/storeopinion-can-com","dateInserted":"2023-06-04T10:10:14+00:00","insertUserID":113545,"insertUser":{"userID":113545,"name":"StoreOpinionCan","title":"StoreOpinion-Can.Com","url":"https:\/\/community.anaplan.com\/profile\/StoreOpinionCan","photoUrl":"https:\/\/w4.vanillicon.com\/v2\/4eeee809f7617daf247d69ad72276c3c.svg","dateLastActive":"2023-06-04T10:07:09+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155867,"type":"question","name":"Help on P&L What-If Optimizer","excerpt":"Hi Everyone, I'm trying to build a Simple Optimizer for P&L where Variables are Volume, Selling Price, Cost Price and Objective is to get a Particular Net Income. I'm getting errors and unable to move forward","categoryID":19,"dateInserted":"2023-06-04T04:21:37+00:00","dateUpdated":null,"dateLastComment":"2023-06-04T04:21:37+00:00","insertUserID":28750,"insertUser":{"userID":28750,"name":"Sai_Bharadwaj_Venati","url":"https:\/\/community.anaplan.com\/profile\/Sai_Bharadwaj_Venati","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28750.png","dateLastActive":"2023-06-07T07:26:49+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/trusted+contributor.png\")
"},"updateUserID":null,"lastUserID":28750,"lastUser":{"userID":28750,"name":"Sai_Bharadwaj_Venati","url":"https:\/\/community.anaplan.com\/profile\/Sai_Bharadwaj_Venati","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28750.png","dateLastActive":"2023-06-07T07:26:49+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":39,"score":1,"hot":1685852797,"url":"https:\/\/community.anaplan.com\/discussion\/155867\/help-on-p-l-what-if-optimizer","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155867\/help-on-p-l-what-if-optimizer","format":"Rich2","tagIDs":[1149],"lastPost":{"discussionID":155867,"name":"Help on P&L What-If Optimizer","url":"https:\/\/community.anaplan.com\/discussion\/155867\/help-on-p-l-what-if-optimizer","dateInserted":"2023-06-04T04:21:37+00:00","insertUserID":28750,"insertUser":{"userID":28750,"name":"Sai_Bharadwaj_Venati","url":"https:\/\/community.anaplan.com\/profile\/Sai_Bharadwaj_Venati","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28750.png","dateLastActive":"2023-06-07T07:26:49+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/LOVTT84ICOBG\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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":1}],"tags":[{"tagID":1149,"urlcode":"optimizer","name":"Optimizer"}]},{"discussionID":155792,"type":"question","name":"How to calculate intercompany ownership% calculation for a group companies?","excerpt":"Problem Statement: I have a requirement where I have to calculate the indirect ownership% of the entities based on the input of direct ownership% Example: The direct ownership% of the entities 'Entity 1' is the ultimate parent'Entity 2' is held by 'Entity 1' by 50%'Entity 3' is held by 'Entity 1' by 100%'Entity 4' is held…","categoryID":182,"dateInserted":"2023-05-25T11:21:31+00:00","dateUpdated":null,"dateLastComment":"2023-05-25T11:21:31+00:00","insertUserID":70951,"insertUser":{"userID":70951,"name":"Aswinraj","url":"https:\/\/community.anaplan.com\/profile\/Aswinraj","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/70951.svg","dateLastActive":"2023-06-06T05:26:42+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":70951,"lastUser":{"userID":70951,"name":"Aswinraj","url":"https:\/\/community.anaplan.com\/profile\/Aswinraj","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/70951.svg","dateLastActive":"2023-06-06T05:26:42+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":54,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155792\/how-to-calculate-intercompany-ownership-calculation-for-a-group-companies","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155792\/how-to-calculate-intercompany-ownership-calculation-for-a-group-companies","format":"Rich2","lastPost":{"discussionID":155792,"name":"How to calculate intercompany ownership% calculation for a group companies?","url":"https:\/\/community.anaplan.com\/discussion\/155792\/how-to-calculate-intercompany-ownership-calculation-for-a-group-companies","dateInserted":"2023-05-25T11:21:31+00:00","insertUserID":70951,"insertUser":{"userID":70951,"name":"Aswinraj","url":"https:\/\/community.anaplan.com\/profile\/Aswinraj","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/70951.svg","dateLastActive":"2023-06-06T05:26:42+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/WXQUES0EDZFW\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155785,"type":"question","name":"Level 2","excerpt":"Hi,","categoryID":182,"dateInserted":"2023-05-24T15:33:43+00:00","dateUpdated":"2023-05-26T16:33:11+00:00","dateLastComment":"2023-05-24T15:33:43+00:00","insertUserID":108033,"insertUser":{"userID":108033,"name":"Mehdi","url":"https:\/\/community.anaplan.com\/profile\/Mehdi","photoUrl":"https:\/\/wa.vanillicon.com\/v2\/a9517f1a1746b5573030e87cb24b79b2.svg","dateLastActive":"2023-06-05T19:12:19+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/member.png\")
"},"updateUserID":108033,"lastUserID":108033,"lastUser":{"userID":108033,"name":"Mehdi","url":"https:\/\/community.anaplan.com\/profile\/Mehdi","photoUrl":"https:\/\/wa.vanillicon.com\/v2\/a9517f1a1746b5573030e87cb24b79b2.svg","dateLastActive":"2023-06-05T19:12:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":54,"score":-1,"hot":3370060914,"url":"https:\/\/community.anaplan.com\/discussion\/155785\/level-2","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155785\/level-2","format":"Rich2","lastPost":{"discussionID":155785,"name":"Level 2","url":"https:\/\/community.anaplan.com\/discussion\/155785\/level-2","dateInserted":"2023-05-24T15:33:43+00:00","insertUserID":108033,"insertUser":{"userID":108033,"name":"Mehdi","url":"https:\/\/community.anaplan.com\/profile\/Mehdi","photoUrl":"https:\/\/wa.vanillicon.com\/v2\/a9517f1a1746b5573030e87cb24b79b2.svg","dateLastActive":"2023-06-05T19:12:19+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155572,"type":"question","name":"Tableau to Anaplan integration","excerpt":"Hi team, Could you please help me with best possible way to export data from Tableau and load it in Anaplan by writing script or something. Regards, Venkatesh","categoryID":182,"dateInserted":"2023-05-02T07:41:53+00:00","dateUpdated":"2023-05-02T07:42:27+00:00","dateLastComment":"2023-05-02T07:41:53+00:00","insertUserID":80604,"insertUser":{"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-07T07:45:23+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":80604,"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-07T07:45:23+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":73,"score":1,"hot":3366026960,"url":"https:\/\/community.anaplan.com\/discussion\/155572\/tableau-to-anaplan-integration","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155572\/tableau-to-anaplan-integration","format":"Rich2","tagIDs":[27,214,1111,1118],"lastPost":{"discussionID":155572,"commentID":157435,"name":"Re: Tableau to Anaplan integration","url":"https:\/\/community.anaplan.com\/discussion\/comment\/157435#Comment_157435","dateInserted":"2023-05-02T07:41:53+00:00","insertUserID":80604,"insertUser":{"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-07T07:45:23+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":"2023-05-04T01:44:27+00:00","dateAnswered":"2023-05-03T15:44:07+00:00","acceptedAnswers":[{"commentID":157435,"body":"
it is solved.<\/p>
<\/p>
\n \n https:\/\/community.anaplan.com\/discussion\/155579\/tableau-to-anaplan-integration\n <\/a>\n<\/div>\n<\/p>"}]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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":1}],"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":214,"urlcode":"CloudWorks","name":"CloudWorks"},{"tagID":1111,"urlcode":"anaplan-community","name":"Anaplan Community"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}]},{"discussionID":155291,"type":"question","name":"Level 3 - Ask the Stakeholders - Designating Sales Reps to Accounts Process Questions","excerpt":"Level 3 - Ask the Stakeholders Designating Sales Reps to Accounts Process QuestionsThis forum is for asking the stakeholders of the Unicorn Candy Company questions about the Designating Sales Reps to Accounts Process. The Anaplan Academy team will be monitoring this forum during US Central standard business hours. Please…","categoryID":182,"dateInserted":"2023-03-28T17:04:27+00:00","dateUpdated":"2023-03-28T22:30:32+00:00","dateLastComment":"2023-03-28T17:04:27+00:00","insertUserID":23007,"insertUser":{"userID":23007,"name":"BeckyO","url":"https:\/\/community.anaplan.com\/profile\/BeckyO","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/23007.png","dateLastActive":"2023-06-06T21:48:49+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/us.v-cdn.net\/6037036\/rank\/1.png\")
"},"updateUserID":365,"lastUserID":23007,"lastUser":{"userID":23007,"name":"BeckyO","url":"https:\/\/community.anaplan.com\/profile\/BeckyO","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/23007.png","dateLastActive":"2023-06-06T21:48:49+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":443,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155291\/level-3-ask-the-stakeholders-designating-sales-reps-to-accounts-process-questions","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155291\/level-3-ask-the-stakeholders-designating-sales-reps-to-accounts-process-questions","format":"Rich2","tagIDs":[37],"lastPost":{"discussionID":155291,"name":"Level 3 - Ask the Stakeholders - Designating Sales Reps to Accounts Process Questions","url":"https:\/\/community.anaplan.com\/discussion\/155291\/level-3-ask-the-stakeholders-designating-sales-reps-to-accounts-process-questions","dateInserted":"2023-03-28T17:04:27+00:00","insertUserID":23007,"insertUser":{"userID":23007,"name":"BeckyO","url":"https:\/\/community.anaplan.com\/profile\/BeckyO","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/23007.png","dateLastActive":"2023-06-06T21:48:49+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"}]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"$seoContent":"
\n \n ✅ Answered questions <\/h2> <\/div>\n \n- \n2.3.9.1 Import data into DAT03 Historic Volumes module<\/a>\n
please any one help to solve this activity .I n mapping i am not getting P3 SKU values so data is not importing<\/p>\n<\/li>\n
- \nMoving Average Issue<\/a>\n
Hi, For my Forecast Jan 2023 I want to bring the (Actuals) AVERAGE of Jan 2021 and Jan 2022. And for my Feb 2023 I want the AVERAGE of Feb 2021 and Feb 2022, e.t.c. To achieve this I split the line item actuals values into the ones below, for calculation and then bring it to the forecast. for 2021 Values line item for 2022…<\/p>\n<\/li>\n
- \nHad L2S3 erased and then recovered now issue with all inventory numbers showing 0<\/a>\n
All models were erased but Anaplan recovered them, but now all my L2S3 that deal with inventory, beginning, reorder, forecast etc, in my Supply Chain models are zeroed out. I have the numbers in my Data Hub models but can't seem to move them to the Supply Chain models. Any Suggestions? Thanks, MPW<\/p>\n<\/li>\n
- \n3.4.3 Activity: Create Country Summary Module<\/a>\n
I have created the module as requested and added below formula, however there is no data reflecting in my INV02. Can anyone suggest where i am going wrong? SYS08 module snip INV02 module formula INV01 snip where my stockcount is shown as 0 completely. INV02 is shown as 0, not sure of error. Kindly let me know, thanks for…<\/p>\n<\/li>\n
- \nTraining procedure<\/a>\n
I m confused to understand the method of training as till now portal is only updated with written content . Will we get video session or this is only content with which we have to move on .<\/p>\n<\/li>\n
- \nCan Data Hub hold formula related data? or just the spoke model is supposed to that?<\/a>\n<\/li>\n
- \nVariance Report Issue<\/a>\n
Hi All, I am creating a variance report using a custom list mapping to a native list in order to bring the data to the module with fake list. After I sum it I noticed the Actuals data is not flowing in the actuals for the target module but in one of the version only, And other versions afre not flowing to the target…<\/p>\n<\/li>\n
- \nassets & Predictive Insight Modelsin anaplan<\/a>\n
Where can we sue this option of Assets and predective insight models in anaplan<\/p>\n<\/li>\n
- \nSprint 3 3.3.5.2C Purchase Order Line Items - Confirmed PO Delivery<\/a>\n
Hi, When i am testing submit purchase order request for Cookie Crumbs_EN. In Week 9 FY20, select the Boolean for Submit Purchase Order Request? Comitted PO delivery should be enabled for Week 13, instead it is enabling for week 5 Please find the formulas i have added below, don't know where i made a mistake, sharing all…<\/p>\n<\/li>\n
- \nExcel Add-in login Issue<\/a>\n
Hello All, Our users are having SSO access to Anaplan, but we are getting a non-sso login page while log-in into the Excel-add-in. We already tried to uninstall\/install the package a few times and we follow the same installation procedure for all the users. Only 3 users are facing this problem and they were able to log in…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"✅ Answered questions ","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","status":"answered","sort":"-dateLastComment","limit":10,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":155893,"type":"question","name":"2.3.9.1 Import data into DAT03 Historic Volumes module","excerpt":"please any one help to solve this activity .I n mapping i am not getting P3 SKU values so data is not importing","categoryID":182,"dateInserted":"2023-06-07T05:14:18+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T06:25:28+00:00","insertUserID":110617,"insertUser":{"userID":110617,"name":"learnerghi","url":"https:\/\/community.anaplan.com\/profile\/learnerghi","photoUrl":"https:\/\/wa.vanillicon.com\/v2\/a4831da83c8b86470ac69f93157d1ceb.svg","dateLastActive":"2023-06-07T05:57:42+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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":14,"score":null,"hot":3372235786,"url":"https:\/\/community.anaplan.com\/discussion\/155893\/2-3-9-1-import-data-into-dat03-historic-volumes-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155893\/2-3-9-1-import-data-into-dat03-historic-volumes-module","format":"Rich2","lastPost":{"discussionID":155893,"commentID":158413,"name":"Re: 2.3.9.1 Import data into DAT03 Historic Volumes module","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158413#Comment_158413","dateInserted":"2023-06-07T06:25:28+00:00","insertUserID":91665,"insertUser":{"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/5LB76ATLXD6W\/activity.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"activity.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T05:44:18+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155886,"type":"question","name":"Moving Average Issue","excerpt":"Hi, For my Forecast Jan 2023 I want to bring the (Actuals) AVERAGE of Jan 2021 and Jan 2022. And for my Feb 2023 I want the AVERAGE of Feb 2021 and Feb 2022, e.t.c. To achieve this I split the line item actuals values into the ones below, for calculation and then bring it to the forecast. for 2021 Values line item for 2022…","categoryID":19,"dateInserted":"2023-06-06T18:36:26+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T05:38:36+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-07T06:36:51+00:00","banned":0,"punished":0,"private":true,"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3372193502,"url":"https:\/\/community.anaplan.com\/discussion\/155886\/moving-average-issue","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155886\/moving-average-issue","format":"Rich2","lastPost":{"discussionID":155886,"commentID":158410,"name":"Re: Moving Average Issue","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158410#Comment_158410","dateInserted":"2023-06-07T05:38:36+00:00","insertUserID":91665,"insertUser":{"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/VIE29P89I03Z\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T05:38:36+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155889,"type":"question","name":"Had L2S3 erased and then recovered now issue with all inventory numbers showing 0","excerpt":"All models were erased but Anaplan recovered them, but now all my L2S3 that deal with inventory, beginning, reorder, forecast etc, in my Supply Chain models are zeroed out. I have the numbers in my Data Hub models but can't seem to move them to the Supply Chain models. Any Suggestions? Thanks, MPW","categoryID":182,"dateInserted":"2023-06-06T20:51:08+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T05:27:00+00:00","insertUserID":106365,"insertUser":{"userID":106365,"name":"MPWall","url":"https:\/\/community.anaplan.com\/profile\/MPWall","photoUrl":"https:\/\/w0.vanillicon.com\/v2\/018d544ff2d200048ec344776786396c.svg","dateLastActive":"2023-06-06T21:46:45+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":64108,"lastUser":{"userID":64108,"name":"krishnadbr","url":"https:\/\/community.anaplan.com\/profile\/krishnadbr","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/64108.png","dateLastActive":"2023-06-07T07:22:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3372200888,"url":"https:\/\/community.anaplan.com\/discussion\/155889\/had-l2s3-erased-and-then-recovered-now-issue-with-all-inventory-numbers-showing-0","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155889\/had-l2s3-erased-and-then-recovered-now-issue-with-all-inventory-numbers-showing-0","format":"Rich2","lastPost":{"discussionID":155889,"commentID":158409,"name":"Re: Had L2S3 erased and then recovered now issue with all inventory numbers showing 0","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158409#Comment_158409","dateInserted":"2023-06-07T05:27:00+00:00","insertUserID":64108,"insertUser":{"userID":64108,"name":"krishnadbr","url":"https:\/\/community.anaplan.com\/profile\/krishnadbr","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/64108.png","dateLastActive":"2023-06-07T07:22:07+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T05:27:00+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155887,"type":"question","name":"3.4.3 Activity: Create Country Summary Module","excerpt":"I have created the module as requested and added below formula, however there is no data reflecting in my INV02. Can anyone suggest where i am going wrong? SYS08 module snip INV02 module formula INV01 snip where my stockcount is shown as 0 completely. INV02 is shown as 0, not sure of error. Kindly let me know, thanks for…","categoryID":19,"dateInserted":"2023-06-06T19:41:23+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T03:27:57+00:00","insertUserID":111534,"insertUser":{"userID":111534,"name":"Smuti","url":"https:\/\/community.anaplan.com\/profile\/Smuti","photoUrl":"https:\/\/w9.vanillicon.com\/v2\/9d5dc2e4b24f8bebc0fc5d8301624714.svg","dateLastActive":"2023-06-06T19:56:12+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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":3372189560,"url":"https:\/\/community.anaplan.com\/discussion\/155887\/3-4-3-activity-create-country-summary-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155887\/3-4-3-activity-create-country-summary-module","format":"Rich2","lastPost":{"discussionID":155887,"commentID":158407,"name":"Re: 3.4.3 Activity: Create Country Summary Module","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158407#Comment_158407","dateInserted":"2023-06-07T03:27:57+00:00","insertUserID":91665,"insertUser":{"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/Q7J68MPDUXXS\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T03:27:57+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155885,"type":"question","name":"Training procedure","excerpt":"I m confused to understand the method of training as till now portal is only updated with written content . Will we get video session or this is only content with which we have to move on .","categoryID":182,"dateInserted":"2023-06-06T16:05:28+00:00","dateUpdated":"2023-06-06T16:06:21+00:00","dateLastComment":"2023-06-06T22:09:33+00:00","insertUserID":113205,"insertUser":{"userID":113205,"name":"VK3105","url":"https:\/\/community.anaplan.com\/profile\/VK3105","photoUrl":"https:\/\/w7.vanillicon.com\/v2\/70b349ddec0ade7760b0fc937ece652a.svg","dateLastActive":"2023-06-06T16:18:42+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":113205,"lastUserID":8014,"lastUser":{"userID":8014,"name":"Tiffany.Rice","url":"https:\/\/community.anaplan.com\/profile\/Tiffany.Rice","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8014.png","dateLastActive":"2023-06-06T22:07:01+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3372157501,"url":"https:\/\/community.anaplan.com\/discussion\/155885\/training-procedure","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155885\/training-procedure","format":"Rich2","lastPost":{"discussionID":155885,"commentID":158404,"name":"Re: Training procedure","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158404#Comment_158404","dateInserted":"2023-06-06T22:09:33+00:00","insertUserID":8014,"insertUser":{"userID":8014,"name":"Tiffany.Rice","url":"https:\/\/community.anaplan.com\/profile\/Tiffany.Rice","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8014.png","dateLastActive":"2023-06-06T22:07:01+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-06T22:09:33+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155875,"type":"question","name":"Can Data Hub hold formula related data? or just the spoke model is supposed to that?","excerpt":"","categoryID":19,"dateInserted":"2023-06-05T17:30:50+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T20:34:07+00:00","insertUserID":105609,"insertUser":{"userID":105609,"name":"shlokhan","url":"https:\/\/community.anaplan.com\/profile\/shlokhan","photoUrl":"https:\/\/w6.vanillicon.com\/v2\/682ef7bc9427273dbde14d950490417b.svg","dateLastActive":"2023-06-06T20:33:07+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":105609,"lastUser":{"userID":105609,"name":"shlokhan","url":"https:\/\/community.anaplan.com\/profile\/shlokhan","photoUrl":"https:\/\/w6.vanillicon.com\/v2\/682ef7bc9427273dbde14d950490417b.svg","dateLastActive":"2023-06-06T20:33:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3372071097,"url":"https:\/\/community.anaplan.com\/discussion\/155875\/can-data-hub-hold-formula-related-data-or-just-the-spoke-model-is-supposed-to-that","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155875\/can-data-hub-hold-formula-related-data-or-just-the-spoke-model-is-supposed-to-that","format":"Rich2","tagIDs":[461,1108,1111],"lastPost":{"discussionID":155875,"commentID":158400,"name":"Re: Can Data Hub hold formula related data? or just the spoke model is supposed to that?","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158400#Comment_158400","dateInserted":"2023-06-06T20:34:07+00:00","insertUserID":105609,"insertUser":{"userID":105609,"name":"shlokhan","url":"https:\/\/community.anaplan.com\/profile\/shlokhan","photoUrl":"https:\/\/w6.vanillicon.com\/v2\/682ef7bc9427273dbde14d950490417b.svg","dateLastActive":"2023-06-06T20:33:07+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-05T17:41:26+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[{"tagID":461,"urlcode":"Data","name":"Data"},{"tagID":1108,"urlcode":"data-hub","name":"Data Hub"},{"tagID":1111,"urlcode":"anaplan-community","name":"Anaplan Community"}]},{"discussionID":155877,"type":"question","name":"Variance Report Issue","excerpt":"Hi All, I am creating a variance report using a custom list mapping to a native list in order to bring the data to the module with fake list. After I sum it I noticed the Actuals data is not flowing in the actuals for the target module but in one of the version only, And other versions afre not flowing to the target…","categoryID":19,"dateInserted":"2023-06-05T23:18:13+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T17:29:15+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-07T06:36:51+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-07T06:36:51+00:00","banned":0,"punished":0,"private":true,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":37,"score":null,"hot":3372081448,"url":"https:\/\/community.anaplan.com\/discussion\/155877\/variance-report-issue","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155877\/variance-report-issue","format":"Rich2","lastPost":{"discussionID":155877,"commentID":158395,"name":"Re: Variance Report Issue","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158395#Comment_158395","dateInserted":"2023-06-06T17:29:15+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-07T06:36:51+00:00","banned":0,"punished":0,"private":true,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/6CUTZF66U5L1\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-06T07:33:23+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155803,"type":"question","name":"assets & Predictive Insight Modelsin anaplan","excerpt":"Where can we sue this option of Assets and predective insight models in anaplan","categoryID":19,"dateInserted":"2023-05-26T10:33:02+00:00","dateUpdated":"2023-05-26T11:57:11+00:00","dateLastComment":"2023-06-06T08:00:07+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-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":78982,"lastUserID":78982,"lastUser":{"userID":78982,"name":"kishoreanimi","url":"https:\/\/community.anaplan.com\/profile\/kishoreanimi","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/78982.png","dateLastActive":"2023-06-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":33,"score":null,"hot":3371136789,"url":"https:\/\/community.anaplan.com\/discussion\/155803\/assets-predictive-insight-modelsin-anaplan","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155803\/assets-predictive-insight-modelsin-anaplan","format":"Rich2","lastPost":{"discussionID":155803,"commentID":158390,"name":"Re: assets & Predictive Insight Modelsin anaplan","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158390#Comment_158390","dateInserted":"2023-06-06T08:00:07+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-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-06T08:00:07+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":152560,"type":"question","name":"Sprint 3 3.3.5.2C Purchase Order Line Items - Confirmed PO Delivery","excerpt":"Hi, When i am testing submit purchase order request for Cookie Crumbs_EN. In Week 9 FY20, select the Boolean for Submit Purchase Order Request? Comitted PO delivery should be enabled for Week 13, instead it is enabling for week 5 Please find the formulas i have added below, don't know where i made a mistake, sharing all…","categoryID":18,"dateInserted":"2022-11-19T03:27:46+00:00","dateUpdated":"2022-11-19T00:00:00+00:00","dateLastComment":"2023-06-06T02:18:03+00:00","insertUserID":92379,"insertUser":{"userID":92379,"name":"SrikarAllena","url":"https:\/\/community.anaplan.com\/profile\/SrikarAllena","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/92379.png","dateLastActive":"2022-11-22T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":111180,"lastUser":{"userID":111180,"name":"PeterYH","url":"https:\/\/community.anaplan.com\/profile\/PeterYH","photoUrl":"https:\/\/w3.vanillicon.com\/v2\/3b908cba8aa15abee378d90c0ab0676b.svg","dateLastActive":"2023-06-07T07:27:57+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":439,"score":null,"hot":3354846949,"url":"https:\/\/community.anaplan.com\/discussion\/152560\/sprint-3-3-3-5-2c-purchase-order-line-items-confirmed-po-delivery","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/152560\/sprint-3-3-3-5-2c-purchase-order-line-items-confirmed-po-delivery","format":"Html","tagIDs":[52,59,1123],"lastPost":{"discussionID":152560,"commentID":158381,"name":"Re: Sprint 3 3.3.5.2C Purchase Order Line Items - Confirmed PO Delivery","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158381#Comment_158381","dateInserted":"2023-06-06T02:18:03+00:00","insertUserID":111180,"insertUser":{"userID":111180,"name":"PeterYH","url":"https:\/\/community.anaplan.com\/profile\/PeterYH","photoUrl":"https:\/\/w3.vanillicon.com\/v2\/3b908cba8aa15abee378d90c0ab0676b.svg","dateLastActive":"2023-06-07T07:27:57+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"User Experience","url":"https:\/\/community.anaplan.com\/categories\/user-experience-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/SrikarAllena_2-1668856797667_152560.png?medium\/strip-exif-data\/true?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SrikarAllena_2-1668856797667.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-06T02:18:03+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":18,"name":"User Experience","url":"https:\/\/community.anaplan.com\/categories\/user-experience-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":59,"urlcode":"Anaplan-Home","name":"Anaplan Home"},{"tagID":1123,"urlcode":"user-experience","name":"User Experience"}]},{"discussionID":83667,"type":"question","name":"Excel Add-in login Issue","excerpt":"Hello All, Our users are having SSO access to Anaplan, but we are getting a non-sso login page while log-in into the Excel-add-in. We already tried to uninstall\/install the package a few times and we follow the same installation procedure for all the users. Only 3 users are facing this problem and they were able to log in…","categoryID":21,"dateInserted":"2020-09-11T07:14:20+00:00","dateUpdated":null,"dateLastComment":"2023-06-05T14:00:00+00:00","insertUserID":11770,"insertUser":{"userID":11770,"name":"VIGNESH.M","url":"https:\/\/community.anaplan.com\/profile\/VIGNESH.M","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/11770.jpeg","dateLastActive":"2023-02-17T22:10:06+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":113637,"lastUser":{"userID":113637,"name":"nicolasdevivies","url":"https:\/\/community.anaplan.com\/profile\/nicolasdevivies","photoUrl":"https:\/\/wd.vanillicon.com\/v2\/d04af07dad0155ebdd7e69e7aeea4cd4.svg","dateLastActive":"2023-06-05T14:08:05+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":35,"score":null,"hot":3285784460,"url":"https:\/\/community.anaplan.com\/discussion\/83667\/excel-add-in-login-issue","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/83667\/excel-add-in-login-issue","format":"html","tagIDs":[24,1118],"lastPost":{"discussionID":83667,"commentID":158323,"name":"Re: Excel Add-in login Issue","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158323#Comment_158323","dateInserted":"2023-06-05T14:00:00+00:00","insertUserID":113637,"insertUser":{"userID":113637,"name":"nicolasdevivies","url":"https:\/\/community.anaplan.com\/profile\/nicolasdevivies","photoUrl":"https:\/\/wd.vanillicon.com\/v2\/d04af07dad0155ebdd7e69e7aeea4cd4.svg","dateLastActive":"2023-06-05T14:08:05+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-09-11T07:34:27+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[{"tagID":24,"urlcode":"Extensions","name":"Extensions"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}}],"defaultTabIndex":0}">
hi there, I would like to build a report which would basically be a P&L where I display the cost per segment in 1 table. My segments being a grouping of a list (departments): my "base" P&L looks like that: and the report I would like to build should look like that: The idea would be to fill in the cost lines (Human…<\/p>\n<\/li>\n
Hi all, How can i define CY end week by formula not hardcode. we dont want to use CY week +52 so any Suggestions<\/p>\n<\/li>\n
please any one help to solve this activity .I n mapping i am not getting P3 SKU values so data is not importing<\/p>\n<\/li>\n
All models were erased but Anaplan recovered them, but now all my L2S3 that deal with inventory, beginning, reorder, forecast etc, in my Supply Chain models are zeroed out. I have the numbers in my Data Hub models but can't seem to move them to the Supply Chain models. Any Suggestions? Thanks, MPW<\/p>\n<\/li>\n
Hi, I have transaction data where i have a period formatted line item with the year and a number formatted line item called Number. I want the maximum number against each year in the Max column. I tried the Number[MAX:Year] but it didn't work. So how can I get the maximum number against each Year? Attaching the screnshot…<\/p>\n<\/li>\n
I have created the module as requested and added below formula, however there is no data reflecting in my INV02. Can anyone suggest where i am going wrong? SYS08 module snip INV02 module formula INV01 snip where my stockcount is shown as 0 completely. INV02 is shown as 0, not sure of error. Kindly let me know, thanks for…<\/p>\n<\/li>\n
Hi, For my Forecast Jan 2023 I want to bring the (Actuals) AVERAGE of Jan 2021 and Jan 2022. And for my Feb 2023 I want the AVERAGE of Feb 2021 and Feb 2022, e.t.c. To achieve this I split the line item actuals values into the ones below, for calculation and then bring it to the forecast. for 2021 Values line item for 2022…<\/p>\n<\/li>\n
I m confused to understand the method of training as till now portal is only updated with written content . Will we get video session or this is only content with which we have to move on .<\/p>\n<\/li>\n
We can filter elements in a list, We can filter Time elements, We can filter Line Items using a Line Item Subset, But can we filter items in a Line Item subset? (All dynamically by a user) Summary of the problem: I use a boolean per user to filter a module sized by a line item subset. The filter worked fine until last…<\/p>\n<\/li>\n
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<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"🚀 Newest questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","sort":"-dateInserted","limit":10,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":155895,"type":"question","name":"SUM IF Anaplan","excerpt":"hi there, I would like to build a report which would basically be a P&L where I display the cost per segment in 1 table. My segments being a grouping of a list (departments): my \"base\" P&L looks like that: and the report I would like to build should look like that: The idea would be to fill in the cost lines (Human…","categoryID":19,"dateInserted":"2023-06-07T07:53:24+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T07:53:24+00:00","insertUserID":60693,"insertUser":{"userID":60693,"name":"HugoManchon","url":"https:\/\/community.anaplan.com\/profile\/HugoManchon","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/60693.png","dateLastActive":"2023-06-07T08:04:58+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":60693,"lastUser":{"userID":60693,"name":"HugoManchon","url":"https:\/\/community.anaplan.com\/profile\/HugoManchon","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/60693.png","dateLastActive":"2023-06-07T08:04:58+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":8,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155895\/sum-if-anaplan","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155895\/sum-if-anaplan","format":"Rich2","lastPost":{"discussionID":155895,"name":"SUM IF Anaplan","url":"https:\/\/community.anaplan.com\/discussion\/155895\/sum-if-anaplan","dateInserted":"2023-06-07T07:53:24+00:00","insertUserID":60693,"insertUser":{"userID":60693,"name":"HugoManchon","url":"https:\/\/community.anaplan.com\/profile\/HugoManchon","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/60693.png","dateLastActive":"2023-06-07T08:04:58+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/U4BBMSNJVDTR\/screenshot-2023-06-07-094421.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-07 094421.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155894,"type":"question","name":"Define current year end week","excerpt":"Hi all, How can i define CY end week by formula not hardcode. we dont want to use CY week +52 so any Suggestions","categoryID":19,"dateInserted":"2023-06-07T06:10:16+00:00","dateUpdated":"2023-06-07T06:10:37+00:00","dateLastComment":"2023-06-07T06:10:16+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-07T08:08:10+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":70306,"lastUserID":70306,"lastUser":{"userID":70306,"name":"143kishornaidu","url":"https:\/\/community.anaplan.com\/profile\/143kishornaidu","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/70306.png","dateLastActive":"2023-06-07T08:08:10+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":10,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155894\/define-current-year-end-week","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155894\/define-current-year-end-week","format":"Rich2","lastPost":{"discussionID":155894,"name":"Define current year end week","url":"https:\/\/community.anaplan.com\/discussion\/155894\/define-current-year-end-week","dateInserted":"2023-06-07T06:10:16+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-07T08:08:10+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/B1ONMQP8DFZ2\/capture-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155893,"type":"question","name":"2.3.9.1 Import data into DAT03 Historic Volumes module","excerpt":"please any one help to solve this activity .I n mapping i am not getting P3 SKU values so data is not importing","categoryID":182,"dateInserted":"2023-06-07T05:14:18+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T06:25:28+00:00","insertUserID":110617,"insertUser":{"userID":110617,"name":"learnerghi","url":"https:\/\/community.anaplan.com\/profile\/learnerghi","photoUrl":"https:\/\/wa.vanillicon.com\/v2\/a4831da83c8b86470ac69f93157d1ceb.svg","dateLastActive":"2023-06-07T05:57:42+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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":14,"score":null,"hot":3372235786,"url":"https:\/\/community.anaplan.com\/discussion\/155893\/2-3-9-1-import-data-into-dat03-historic-volumes-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155893\/2-3-9-1-import-data-into-dat03-historic-volumes-module","format":"Rich2","lastPost":{"discussionID":155893,"commentID":158413,"name":"Re: 2.3.9.1 Import data into DAT03 Historic Volumes module","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158413#Comment_158413","dateInserted":"2023-06-07T06:25:28+00:00","insertUserID":91665,"insertUser":{"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/5LB76ATLXD6W\/activity.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"activity.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T05:44:18+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155889,"type":"question","name":"Had L2S3 erased and then recovered now issue with all inventory numbers showing 0","excerpt":"All models were erased but Anaplan recovered them, but now all my L2S3 that deal with inventory, beginning, reorder, forecast etc, in my Supply Chain models are zeroed out. I have the numbers in my Data Hub models but can't seem to move them to the Supply Chain models. Any Suggestions? Thanks, MPW","categoryID":182,"dateInserted":"2023-06-06T20:51:08+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T05:27:00+00:00","insertUserID":106365,"insertUser":{"userID":106365,"name":"MPWall","url":"https:\/\/community.anaplan.com\/profile\/MPWall","photoUrl":"https:\/\/w0.vanillicon.com\/v2\/018d544ff2d200048ec344776786396c.svg","dateLastActive":"2023-06-06T21:46:45+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":64108,"lastUser":{"userID":64108,"name":"krishnadbr","url":"https:\/\/community.anaplan.com\/profile\/krishnadbr","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/64108.png","dateLastActive":"2023-06-07T07:22:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3372200888,"url":"https:\/\/community.anaplan.com\/discussion\/155889\/had-l2s3-erased-and-then-recovered-now-issue-with-all-inventory-numbers-showing-0","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155889\/had-l2s3-erased-and-then-recovered-now-issue-with-all-inventory-numbers-showing-0","format":"Rich2","lastPost":{"discussionID":155889,"commentID":158409,"name":"Re: Had L2S3 erased and then recovered now issue with all inventory numbers showing 0","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158409#Comment_158409","dateInserted":"2023-06-07T05:27:00+00:00","insertUserID":64108,"insertUser":{"userID":64108,"name":"krishnadbr","url":"https:\/\/community.anaplan.com\/profile\/krishnadbr","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/64108.png","dateLastActive":"2023-06-07T07:22:07+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T05:27:00+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155888,"type":"question","name":"Get Maximum number against year in a transaction data?","excerpt":"Hi, I have transaction data where i have a period formatted line item with the year and a number formatted line item called Number. I want the maximum number against each year in the Max column. I tried the Number[MAX:Year] but it didn't work. So how can I get the maximum number against each Year? Attaching the screnshot…","categoryID":19,"dateInserted":"2023-06-06T20:50:54+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T21:12:36+00:00","insertUserID":28464,"insertUser":{"userID":28464,"name":"Arnab116","url":"https:\/\/community.anaplan.com\/profile\/Arnab116","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28464.svg","dateLastActive":"2023-06-06T21:13:49+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":28464,"lastUser":{"userID":28464,"name":"Arnab116","url":"https:\/\/community.anaplan.com\/profile\/Arnab116","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28464.svg","dateLastActive":"2023-06-06T21:13:49+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3372171810,"url":"https:\/\/community.anaplan.com\/discussion\/155888\/get-maximum-number-against-year-in-a-transaction-data","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155888\/get-maximum-number-against-year-in-a-transaction-data","format":"Rich2","lastPost":{"discussionID":155888,"commentID":158402,"name":"Re: Get Maximum number against year in a transaction data?","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158402#Comment_158402","dateInserted":"2023-06-06T21:12:36+00:00","insertUserID":28464,"insertUser":{"userID":28464,"name":"Arnab116","url":"https:\/\/community.anaplan.com\/profile\/Arnab116","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28464.svg","dateLastActive":"2023-06-06T21:13:49+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/4ARW1IFE1BBM\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-06T21:12:11+00:00","dateAnswered":"2023-06-06T21:06:51+00:00","acceptedAnswers":[{"commentID":158401,"body":"
@Arnab116<\/a> <\/p> In another module dimensionalized by your Year (the members in Year Format), try this formula<\/p> Above Module Name.Number[MAX: Year Format]<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155887,"type":"question","name":"3.4.3 Activity: Create Country Summary Module","excerpt":"I have created the module as requested and added below formula, however there is no data reflecting in my INV02. Can anyone suggest where i am going wrong? SYS08 module snip INV02 module formula INV01 snip where my stockcount is shown as 0 completely. INV02 is shown as 0, not sure of error. Kindly let me know, thanks for…","categoryID":19,"dateInserted":"2023-06-06T19:41:23+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T03:27:57+00:00","insertUserID":111534,"insertUser":{"userID":111534,"name":"Smuti","url":"https:\/\/community.anaplan.com\/profile\/Smuti","photoUrl":"https:\/\/w9.vanillicon.com\/v2\/9d5dc2e4b24f8bebc0fc5d8301624714.svg","dateLastActive":"2023-06-06T19:56:12+00:00","banned":0,"punished":0,"private":false,"label":" hi there, I would like to build a report which would basically be a P&L where I display the cost per segment in 1 table. My segments being a grouping of a list (departments): my "base" P&L looks like that: and the report I would like to build should look like that: The idea would be to fill in the cost lines (Human…<\/p>\n<\/li>\n Hi all, How can i define CY end week by formula not hardcode. we dont want to use CY week +52 so any Suggestions<\/p>\n<\/li>\n We can filter elements in a list, We can filter Time elements, We can filter Line Items using a Line Item Subset, But can we filter items in a Line Item subset? (All dynamically by a user) Summary of the problem: I use a boolean per user to filter a module sized by a line item subset. The filter worked fine until last…<\/p>\n<\/li>\n 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<\/p>\n<\/li>\n Loblaws is a great retail store in Canada. It provides a survey named StoreOpinion, in the part of the survey Loblaws announced a great reward for the survey winners. By participating in the Loblaws official survey at StoreOpinion.CA get a chance to win a $1000 Optimum PC gift card.<\/p>\n<\/li>\n Hi Everyone, I'm trying to build a Simple Optimizer for P&L where Variables are Volume, Selling Price, Cost Price and Objective is to get a Particular Net Income. I'm getting errors and unable to move forward<\/p>\n<\/li>\n Problem Statement: I have a requirement where I have to calculate the indirect ownership% of the entities based on the input of direct ownership% Example: The direct ownership% of the entities 'Entity 1' is the ultimate parent'Entity 2' is held by 'Entity 1' by 50%'Entity 3' is held by 'Entity 1' by 100%'Entity 4' is held…<\/p>\n<\/li>\n Hi,<\/p>\n<\/li>\n Hi team, Could you please help me with best possible way to export data from Tableau and load it in Anaplan by writing script or something. Regards, Venkatesh<\/p>\n<\/li>\n Level 3 - Ask the Stakeholders Designating Sales Reps to Accounts Process QuestionsThis forum is for asking the stakeholders of the Unicorn Candy Company questions about the Designating Sales Reps to Accounts Process. The Anaplan Academy team will be monitoring this forum during US Central standard business hours. Please…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"❓ Unanswered questions","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","status":"unanswered","sort":"-dateLastComment","limit":10,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":155895,"type":"question","name":"SUM IF Anaplan","excerpt":"hi there, I would like to build a report which would basically be a P&L where I display the cost per segment in 1 table. My segments being a grouping of a list (departments): my \"base\" P&L looks like that: and the report I would like to build should look like that: The idea would be to fill in the cost lines (Human…","categoryID":19,"dateInserted":"2023-06-07T07:53:24+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T07:53:24+00:00","insertUserID":60693,"insertUser":{"userID":60693,"name":"HugoManchon","url":"https:\/\/community.anaplan.com\/profile\/HugoManchon","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/60693.png","dateLastActive":"2023-06-07T08:04:58+00:00","banned":0,"punished":0,"private":false,"label":" it is solved.<\/p> <\/p>"}]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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":1}],"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":214,"urlcode":"CloudWorks","name":"CloudWorks"},{"tagID":1111,"urlcode":"anaplan-community","name":"Anaplan Community"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}]},{"discussionID":155291,"type":"question","name":"Level 3 - Ask the Stakeholders - Designating Sales Reps to Accounts Process Questions","excerpt":"Level 3 - Ask the Stakeholders Designating Sales Reps to Accounts Process QuestionsThis forum is for asking the stakeholders of the Unicorn Candy Company questions about the Designating Sales Reps to Accounts Process. The Anaplan Academy team will be monitoring this forum during US Central standard business hours. Please…","categoryID":182,"dateInserted":"2023-03-28T17:04:27+00:00","dateUpdated":"2023-03-28T22:30:32+00:00","dateLastComment":"2023-03-28T17:04:27+00:00","insertUserID":23007,"insertUser":{"userID":23007,"name":"BeckyO","url":"https:\/\/community.anaplan.com\/profile\/BeckyO","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/23007.png","dateLastActive":"2023-06-06T21:48:49+00:00","banned":0,"punished":0,"private":false,"label":" please any one help to solve this activity .I n mapping i am not getting P3 SKU values so data is not importing<\/p>\n<\/li>\n Hi, For my Forecast Jan 2023 I want to bring the (Actuals) AVERAGE of Jan 2021 and Jan 2022. And for my Feb 2023 I want the AVERAGE of Feb 2021 and Feb 2022, e.t.c. To achieve this I split the line item actuals values into the ones below, for calculation and then bring it to the forecast. for 2021 Values line item for 2022…<\/p>\n<\/li>\n All models were erased but Anaplan recovered them, but now all my L2S3 that deal with inventory, beginning, reorder, forecast etc, in my Supply Chain models are zeroed out. I have the numbers in my Data Hub models but can't seem to move them to the Supply Chain models. Any Suggestions? Thanks, MPW<\/p>\n<\/li>\n I have created the module as requested and added below formula, however there is no data reflecting in my INV02. Can anyone suggest where i am going wrong? SYS08 module snip INV02 module formula INV01 snip where my stockcount is shown as 0 completely. INV02 is shown as 0, not sure of error. Kindly let me know, thanks for…<\/p>\n<\/li>\n I m confused to understand the method of training as till now portal is only updated with written content . Will we get video session or this is only content with which we have to move on .<\/p>\n<\/li>\n Hi All, I am creating a variance report using a custom list mapping to a native list in order to bring the data to the module with fake list. After I sum it I noticed the Actuals data is not flowing in the actuals for the target module but in one of the version only, And other versions afre not flowing to the target…<\/p>\n<\/li>\n Where can we sue this option of Assets and predective insight models in anaplan<\/p>\n<\/li>\n Hi, When i am testing submit purchase order request for Cookie Crumbs_EN. In Week 9 FY20, select the Boolean for Submit Purchase Order Request? Comitted PO delivery should be enabled for Week 13, instead it is enabling for week 5 Please find the formulas i have added below, don't know where i made a mistake, sharing all…<\/p>\n<\/li>\n Hello All, Our users are having SSO access to Anaplan, but we are getting a non-sso login page while log-in into the Excel-add-in. We already tried to uninstall\/install the package a few times and we follow the same installation procedure for all the users. Only 3 users are facing this problem and they were able to log in…<\/p>\n<\/li>\n<\/ul>\n <\/div>","label":"✅ Answered questions ","componentName":"DiscussionListModule","componentProps":{"apiParams":{"type":"question","status":"answered","sort":"-dateLastComment","limit":10,"featuredImage":false,"followed":false,"categoryID":null,"includeChildCategories":true,"siteSectionID":"0","expand":["all","-body"],"excludeHiddenCategories":true},"discussions":[{"discussionID":155893,"type":"question","name":"2.3.9.1 Import data into DAT03 Historic Volumes module","excerpt":"please any one help to solve this activity .I n mapping i am not getting P3 SKU values so data is not importing","categoryID":182,"dateInserted":"2023-06-07T05:14:18+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T06:25:28+00:00","insertUserID":110617,"insertUser":{"userID":110617,"name":"learnerghi","url":"https:\/\/community.anaplan.com\/profile\/learnerghi","photoUrl":"https:\/\/wa.vanillicon.com\/v2\/a4831da83c8b86470ac69f93157d1ceb.svg","dateLastActive":"2023-06-07T05:57:42+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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":3372189560,"url":"https:\/\/community.anaplan.com\/discussion\/155887\/3-4-3-activity-create-country-summary-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155887\/3-4-3-activity-create-country-summary-module","format":"Rich2","lastPost":{"discussionID":155887,"commentID":158407,"name":"Re: 3.4.3 Activity: Create Country Summary Module","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158407#Comment_158407","dateInserted":"2023-06-07T03:27:57+00:00","insertUserID":91665,"insertUser":{"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/Q7J68MPDUXXS\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T03:27:57+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155886,"type":"question","name":"Moving Average Issue","excerpt":"Hi, For my Forecast Jan 2023 I want to bring the (Actuals) AVERAGE of Jan 2021 and Jan 2022. And for my Feb 2023 I want the AVERAGE of Feb 2021 and Feb 2022, e.t.c. To achieve this I split the line item actuals values into the ones below, for calculation and then bring it to the forecast. for 2021 Values line item for 2022…","categoryID":19,"dateInserted":"2023-06-06T18:36:26+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T05:38:36+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-07T06:36:51+00:00","banned":0,"punished":0,"private":true,"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3372193502,"url":"https:\/\/community.anaplan.com\/discussion\/155886\/moving-average-issue","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155886\/moving-average-issue","format":"Rich2","lastPost":{"discussionID":155886,"commentID":158410,"name":"Re: Moving Average Issue","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158410#Comment_158410","dateInserted":"2023-06-07T05:38:36+00:00","insertUserID":91665,"insertUser":{"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/VIE29P89I03Z\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T05:38:36+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155885,"type":"question","name":"Training procedure","excerpt":"I m confused to understand the method of training as till now portal is only updated with written content . Will we get video session or this is only content with which we have to move on .","categoryID":182,"dateInserted":"2023-06-06T16:05:28+00:00","dateUpdated":"2023-06-06T16:06:21+00:00","dateLastComment":"2023-06-06T22:09:33+00:00","insertUserID":113205,"insertUser":{"userID":113205,"name":"VK3105","url":"https:\/\/community.anaplan.com\/profile\/VK3105","photoUrl":"https:\/\/w7.vanillicon.com\/v2\/70b349ddec0ade7760b0fc937ece652a.svg","dateLastActive":"2023-06-06T16:18:42+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":113205,"lastUserID":8014,"lastUser":{"userID":8014,"name":"Tiffany.Rice","url":"https:\/\/community.anaplan.com\/profile\/Tiffany.Rice","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8014.png","dateLastActive":"2023-06-06T22:07:01+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3372157501,"url":"https:\/\/community.anaplan.com\/discussion\/155885\/training-procedure","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155885\/training-procedure","format":"Rich2","lastPost":{"discussionID":155885,"commentID":158404,"name":"Re: Training procedure","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158404#Comment_158404","dateInserted":"2023-06-06T22:09:33+00:00","insertUserID":8014,"insertUser":{"userID":8014,"name":"Tiffany.Rice","url":"https:\/\/community.anaplan.com\/profile\/Tiffany.Rice","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8014.png","dateLastActive":"2023-06-06T22:07:01+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-06T22:09:33+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155884,"type":"question","name":"How to filter elements of a Line Item subset by user","excerpt":"We can filter elements in a list, We can filter Time elements, We can filter Line Items using a Line Item Subset, But can we filter items in a Line Item subset? (All dynamically by a user) Summary of the problem: I use a boolean per user to filter a module sized by a line item subset. The filter worked fine until last…","categoryID":18,"dateInserted":"2023-06-06T14:54:51+00:00","dateUpdated":"2023-06-06T15:00:09+00:00","dateLastComment":"2023-06-06T14:54:51+00:00","insertUserID":14875,"insertUser":{"userID":14875,"name":"axel.frot","url":"https:\/\/community.anaplan.com\/profile\/axel.frot","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14875.png","dateLastActive":"2023-06-07T06:51:13+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":14875,"lastUserID":14875,"lastUser":{"userID":14875,"name":"axel.frot","url":"https:\/\/community.anaplan.com\/profile\/axel.frot","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14875.png","dateLastActive":"2023-06-07T06:51:13+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":18,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155884\/how-to-filter-elements-of-a-line-item-subset-by-user","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155884\/how-to-filter-elements-of-a-line-item-subset-by-user","format":"Rich2","lastPost":{"discussionID":155884,"name":"How to filter elements of a Line Item subset by user","url":"https:\/\/community.anaplan.com\/discussion\/155884\/how-to-filter-elements-of-a-line-item-subset-by-user","dateInserted":"2023-06-06T14:54:51+00:00","insertUserID":14875,"insertUser":{"userID":14875,"name":"axel.frot","url":"https:\/\/community.anaplan.com\/profile\/axel.frot","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14875.png","dateLastActive":"2023-06-07T06:51:13+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"User Experience","url":"https:\/\/community.anaplan.com\/categories\/user-experience-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/JYEWMXTZPTKX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":18,"name":"User Experience","url":"https:\/\/community.anaplan.com\/categories\/user-experience-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"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-06T08:06:03+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-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":78982,"lastUser":{"userID":78982,"name":"kishoreanimi","url":"https:\/\/community.anaplan.com\/profile\/kishoreanimi","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/78982.png","dateLastActive":"2023-06-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":20,"score":null,"hot":0,"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","lastPost":{"discussionID":155882,"name":"calculate time settings with out hard coding","url":"https:\/\/community.anaplan.com\/discussion\/155882\/calculate-time-settings-with-out-hard-coding","dateInserted":"2023-06-06T08:06:03+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-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"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":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"$seoContent":"❓ Unanswered questions<\/h2> <\/div>\n
\n
"},"updateUserID":null,"lastUserID":60693,"lastUser":{"userID":60693,"name":"HugoManchon","url":"https:\/\/community.anaplan.com\/profile\/HugoManchon","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/60693.png","dateLastActive":"2023-06-07T08:04:58+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":8,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155895\/sum-if-anaplan","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155895\/sum-if-anaplan","format":"Rich2","lastPost":{"discussionID":155895,"name":"SUM IF Anaplan","url":"https:\/\/community.anaplan.com\/discussion\/155895\/sum-if-anaplan","dateInserted":"2023-06-07T07:53:24+00:00","insertUserID":60693,"insertUser":{"userID":60693,"name":"HugoManchon","url":"https:\/\/community.anaplan.com\/profile\/HugoManchon","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/60693.png","dateLastActive":"2023-06-07T08:04:58+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/U4BBMSNJVDTR\/screenshot-2023-06-07-094421.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-06-07 094421.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155894,"type":"question","name":"Define current year end week","excerpt":"Hi all, How can i define CY end week by formula not hardcode. we dont want to use CY week +52 so any Suggestions","categoryID":19,"dateInserted":"2023-06-07T06:10:16+00:00","dateUpdated":"2023-06-07T06:10:37+00:00","dateLastComment":"2023-06-07T06:10:16+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-07T08:08:10+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":70306,"lastUserID":70306,"lastUser":{"userID":70306,"name":"143kishornaidu","url":"https:\/\/community.anaplan.com\/profile\/143kishornaidu","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/70306.png","dateLastActive":"2023-06-07T08:08:10+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":10,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155894\/define-current-year-end-week","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155894\/define-current-year-end-week","format":"Rich2","lastPost":{"discussionID":155894,"name":"Define current year end week","url":"https:\/\/community.anaplan.com\/discussion\/155894\/define-current-year-end-week","dateInserted":"2023-06-07T06:10:16+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-07T08:08:10+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/B1ONMQP8DFZ2\/capture-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155884,"type":"question","name":"How to filter elements of a Line Item subset by user","excerpt":"We can filter elements in a list, We can filter Time elements, We can filter Line Items using a Line Item Subset, But can we filter items in a Line Item subset? (All dynamically by a user) Summary of the problem: I use a boolean per user to filter a module sized by a line item subset. The filter worked fine until last…","categoryID":18,"dateInserted":"2023-06-06T14:54:51+00:00","dateUpdated":"2023-06-06T15:00:09+00:00","dateLastComment":"2023-06-06T14:54:51+00:00","insertUserID":14875,"insertUser":{"userID":14875,"name":"axel.frot","url":"https:\/\/community.anaplan.com\/profile\/axel.frot","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14875.png","dateLastActive":"2023-06-07T06:51:13+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":14875,"lastUserID":14875,"lastUser":{"userID":14875,"name":"axel.frot","url":"https:\/\/community.anaplan.com\/profile\/axel.frot","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14875.png","dateLastActive":"2023-06-07T06:51:13+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":18,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155884\/how-to-filter-elements-of-a-line-item-subset-by-user","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155884\/how-to-filter-elements-of-a-line-item-subset-by-user","format":"Rich2","lastPost":{"discussionID":155884,"name":"How to filter elements of a Line Item subset by user","url":"https:\/\/community.anaplan.com\/discussion\/155884\/how-to-filter-elements-of-a-line-item-subset-by-user","dateInserted":"2023-06-06T14:54:51+00:00","insertUserID":14875,"insertUser":{"userID":14875,"name":"axel.frot","url":"https:\/\/community.anaplan.com\/profile\/axel.frot","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14875.png","dateLastActive":"2023-06-07T06:51:13+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"User Experience","url":"https:\/\/community.anaplan.com\/categories\/user-experience-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/JYEWMXTZPTKX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":18,"name":"User Experience","url":"https:\/\/community.anaplan.com\/categories\/user-experience-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"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-06T08:06:03+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-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":78982,"lastUser":{"userID":78982,"name":"kishoreanimi","url":"https:\/\/community.anaplan.com\/profile\/kishoreanimi","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/78982.png","dateLastActive":"2023-06-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":20,"score":null,"hot":0,"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","lastPost":{"discussionID":155882,"name":"calculate time settings with out hard coding","url":"https:\/\/community.anaplan.com\/discussion\/155882\/calculate-time-settings-with-out-hard-coding","dateInserted":"2023-06-06T08:06:03+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-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"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":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155868,"type":"question","name":"StoreOpinion-Can.Com","excerpt":"Loblaws is a great retail store in Canada. It provides a survey named StoreOpinion, in the part of the survey Loblaws announced a great reward for the survey winners. By participating in the Loblaws official survey at StoreOpinion.CA get a chance to win a $1000 Optimum PC gift card.","categoryID":182,"dateInserted":"2023-06-04T10:10:14+00:00","dateUpdated":null,"dateLastComment":"2023-06-04T10:10:14+00:00","insertUserID":113545,"insertUser":{"userID":113545,"name":"StoreOpinionCan","title":"StoreOpinion-Can.Com","url":"https:\/\/community.anaplan.com\/profile\/StoreOpinionCan","photoUrl":"https:\/\/w4.vanillicon.com\/v2\/4eeee809f7617daf247d69ad72276c3c.svg","dateLastActive":"2023-06-04T10:07:09+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":113545,"lastUser":{"userID":113545,"name":"StoreOpinionCan","title":"StoreOpinion-Can.Com","url":"https:\/\/community.anaplan.com\/profile\/StoreOpinionCan","photoUrl":"https:\/\/w4.vanillicon.com\/v2\/4eeee809f7617daf247d69ad72276c3c.svg","dateLastActive":"2023-06-04T10:07:09+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":24,"score":-2,"hot":1685872814,"url":"https:\/\/community.anaplan.com\/discussion\/155868\/storeopinion-can-com","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155868\/storeopinion-can-com","format":"Rich2","lastPost":{"discussionID":155868,"name":"StoreOpinion-Can.Com","url":"https:\/\/community.anaplan.com\/discussion\/155868\/storeopinion-can-com","dateInserted":"2023-06-04T10:10:14+00:00","insertUserID":113545,"insertUser":{"userID":113545,"name":"StoreOpinionCan","title":"StoreOpinion-Can.Com","url":"https:\/\/community.anaplan.com\/profile\/StoreOpinionCan","photoUrl":"https:\/\/w4.vanillicon.com\/v2\/4eeee809f7617daf247d69ad72276c3c.svg","dateLastActive":"2023-06-04T10:07:09+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155867,"type":"question","name":"Help on P&L What-If Optimizer","excerpt":"Hi Everyone, I'm trying to build a Simple Optimizer for P&L where Variables are Volume, Selling Price, Cost Price and Objective is to get a Particular Net Income. I'm getting errors and unable to move forward","categoryID":19,"dateInserted":"2023-06-04T04:21:37+00:00","dateUpdated":null,"dateLastComment":"2023-06-04T04:21:37+00:00","insertUserID":28750,"insertUser":{"userID":28750,"name":"Sai_Bharadwaj_Venati","url":"https:\/\/community.anaplan.com\/profile\/Sai_Bharadwaj_Venati","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28750.png","dateLastActive":"2023-06-07T07:26:49+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":28750,"lastUser":{"userID":28750,"name":"Sai_Bharadwaj_Venati","url":"https:\/\/community.anaplan.com\/profile\/Sai_Bharadwaj_Venati","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28750.png","dateLastActive":"2023-06-07T07:26:49+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":39,"score":1,"hot":1685852797,"url":"https:\/\/community.anaplan.com\/discussion\/155867\/help-on-p-l-what-if-optimizer","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155867\/help-on-p-l-what-if-optimizer","format":"Rich2","tagIDs":[1149],"lastPost":{"discussionID":155867,"name":"Help on P&L What-If Optimizer","url":"https:\/\/community.anaplan.com\/discussion\/155867\/help-on-p-l-what-if-optimizer","dateInserted":"2023-06-04T04:21:37+00:00","insertUserID":28750,"insertUser":{"userID":28750,"name":"Sai_Bharadwaj_Venati","url":"https:\/\/community.anaplan.com\/profile\/Sai_Bharadwaj_Venati","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28750.png","dateLastActive":"2023-06-07T07:26:49+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/LOVTT84ICOBG\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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":1}],"tags":[{"tagID":1149,"urlcode":"optimizer","name":"Optimizer"}]},{"discussionID":155792,"type":"question","name":"How to calculate intercompany ownership% calculation for a group companies?","excerpt":"Problem Statement: I have a requirement where I have to calculate the indirect ownership% of the entities based on the input of direct ownership% Example: The direct ownership% of the entities 'Entity 1' is the ultimate parent'Entity 2' is held by 'Entity 1' by 50%'Entity 3' is held by 'Entity 1' by 100%'Entity 4' is held…","categoryID":182,"dateInserted":"2023-05-25T11:21:31+00:00","dateUpdated":null,"dateLastComment":"2023-05-25T11:21:31+00:00","insertUserID":70951,"insertUser":{"userID":70951,"name":"Aswinraj","url":"https:\/\/community.anaplan.com\/profile\/Aswinraj","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/70951.svg","dateLastActive":"2023-06-06T05:26:42+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":70951,"lastUser":{"userID":70951,"name":"Aswinraj","url":"https:\/\/community.anaplan.com\/profile\/Aswinraj","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/70951.svg","dateLastActive":"2023-06-06T05:26:42+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":54,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155792\/how-to-calculate-intercompany-ownership-calculation-for-a-group-companies","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155792\/how-to-calculate-intercompany-ownership-calculation-for-a-group-companies","format":"Rich2","lastPost":{"discussionID":155792,"name":"How to calculate intercompany ownership% calculation for a group companies?","url":"https:\/\/community.anaplan.com\/discussion\/155792\/how-to-calculate-intercompany-ownership-calculation-for-a-group-companies","dateInserted":"2023-05-25T11:21:31+00:00","insertUserID":70951,"insertUser":{"userID":70951,"name":"Aswinraj","url":"https:\/\/community.anaplan.com\/profile\/Aswinraj","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/70951.svg","dateLastActive":"2023-06-06T05:26:42+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":1,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/WXQUES0EDZFW\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155785,"type":"question","name":"Level 2","excerpt":"Hi,","categoryID":182,"dateInserted":"2023-05-24T15:33:43+00:00","dateUpdated":"2023-05-26T16:33:11+00:00","dateLastComment":"2023-05-24T15:33:43+00:00","insertUserID":108033,"insertUser":{"userID":108033,"name":"Mehdi","url":"https:\/\/community.anaplan.com\/profile\/Mehdi","photoUrl":"https:\/\/wa.vanillicon.com\/v2\/a9517f1a1746b5573030e87cb24b79b2.svg","dateLastActive":"2023-06-05T19:12:19+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":108033,"lastUserID":108033,"lastUser":{"userID":108033,"name":"Mehdi","url":"https:\/\/community.anaplan.com\/profile\/Mehdi","photoUrl":"https:\/\/wa.vanillicon.com\/v2\/a9517f1a1746b5573030e87cb24b79b2.svg","dateLastActive":"2023-06-05T19:12:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":54,"score":-1,"hot":3370060914,"url":"https:\/\/community.anaplan.com\/discussion\/155785\/level-2","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155785\/level-2","format":"Rich2","lastPost":{"discussionID":155785,"name":"Level 2","url":"https:\/\/community.anaplan.com\/discussion\/155785\/level-2","dateInserted":"2023-05-24T15:33:43+00:00","insertUserID":108033,"insertUser":{"userID":108033,"name":"Mehdi","url":"https:\/\/community.anaplan.com\/profile\/Mehdi","photoUrl":"https:\/\/wa.vanillicon.com\/v2\/a9517f1a1746b5573030e87cb24b79b2.svg","dateLastActive":"2023-06-05T19:12:19+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155572,"type":"question","name":"Tableau to Anaplan integration","excerpt":"Hi team, Could you please help me with best possible way to export data from Tableau and load it in Anaplan by writing script or something. Regards, Venkatesh","categoryID":182,"dateInserted":"2023-05-02T07:41:53+00:00","dateUpdated":"2023-05-02T07:42:27+00:00","dateLastComment":"2023-05-02T07:41:53+00:00","insertUserID":80604,"insertUser":{"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-07T07:45:23+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":80604,"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-07T07:45:23+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":73,"score":1,"hot":3366026960,"url":"https:\/\/community.anaplan.com\/discussion\/155572\/tableau-to-anaplan-integration","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155572\/tableau-to-anaplan-integration","format":"Rich2","tagIDs":[27,214,1111,1118],"lastPost":{"discussionID":155572,"commentID":157435,"name":"Re: Tableau to Anaplan integration","url":"https:\/\/community.anaplan.com\/discussion\/comment\/157435#Comment_157435","dateInserted":"2023-05-02T07:41:53+00:00","insertUserID":80604,"insertUser":{"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-07T07:45:23+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":"2023-05-04T01:44:27+00:00","dateAnswered":"2023-05-03T15:44:07+00:00","acceptedAnswers":[{"commentID":157435,"body":"
<\/p>"},"updateUserID":365,"lastUserID":23007,"lastUser":{"userID":23007,"name":"BeckyO","url":"https:\/\/community.anaplan.com\/profile\/BeckyO","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/23007.png","dateLastActive":"2023-06-06T21:48:49+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":443,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155291\/level-3-ask-the-stakeholders-designating-sales-reps-to-accounts-process-questions","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155291\/level-3-ask-the-stakeholders-designating-sales-reps-to-accounts-process-questions","format":"Rich2","tagIDs":[37],"lastPost":{"discussionID":155291,"name":"Level 3 - Ask the Stakeholders - Designating Sales Reps to Accounts Process Questions","url":"https:\/\/community.anaplan.com\/discussion\/155291\/level-3-ask-the-stakeholders-designating-sales-reps-to-accounts-process-questions","dateInserted":"2023-03-28T17:04:27+00:00","insertUserID":23007,"insertUser":{"userID":23007,"name":"BeckyO","url":"https:\/\/community.anaplan.com\/profile\/BeckyO","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/23007.png","dateLastActive":"2023-06-06T21:48:49+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":1,"attributes":{"question":{"status":"unanswered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"status":{"statusID":1,"name":"Unanswered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"}]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}},{"$seoContent":"✅ Answered questions <\/h2> <\/div>\n
\n
"},"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":14,"score":null,"hot":3372235786,"url":"https:\/\/community.anaplan.com\/discussion\/155893\/2-3-9-1-import-data-into-dat03-historic-volumes-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155893\/2-3-9-1-import-data-into-dat03-historic-volumes-module","format":"Rich2","lastPost":{"discussionID":155893,"commentID":158413,"name":"Re: 2.3.9.1 Import data into DAT03 Historic Volumes module","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158413#Comment_158413","dateInserted":"2023-06-07T06:25:28+00:00","insertUserID":91665,"insertUser":{"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/5LB76ATLXD6W\/activity.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"activity.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T05:44:18+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155886,"type":"question","name":"Moving Average Issue","excerpt":"Hi, For my Forecast Jan 2023 I want to bring the (Actuals) AVERAGE of Jan 2021 and Jan 2022. And for my Feb 2023 I want the AVERAGE of Feb 2021 and Feb 2022, e.t.c. To achieve this I split the line item actuals values into the ones below, for calculation and then bring it to the forecast. for 2021 Values line item for 2022…","categoryID":19,"dateInserted":"2023-06-06T18:36:26+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T05:38:36+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-07T06:36:51+00:00","banned":0,"punished":0,"private":true,"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3372193502,"url":"https:\/\/community.anaplan.com\/discussion\/155886\/moving-average-issue","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155886\/moving-average-issue","format":"Rich2","lastPost":{"discussionID":155886,"commentID":158410,"name":"Re: Moving Average Issue","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158410#Comment_158410","dateInserted":"2023-06-07T05:38:36+00:00","insertUserID":91665,"insertUser":{"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/VIE29P89I03Z\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T05:38:36+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155889,"type":"question","name":"Had L2S3 erased and then recovered now issue with all inventory numbers showing 0","excerpt":"All models were erased but Anaplan recovered them, but now all my L2S3 that deal with inventory, beginning, reorder, forecast etc, in my Supply Chain models are zeroed out. I have the numbers in my Data Hub models but can't seem to move them to the Supply Chain models. Any Suggestions? Thanks, MPW","categoryID":182,"dateInserted":"2023-06-06T20:51:08+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T05:27:00+00:00","insertUserID":106365,"insertUser":{"userID":106365,"name":"MPWall","url":"https:\/\/community.anaplan.com\/profile\/MPWall","photoUrl":"https:\/\/w0.vanillicon.com\/v2\/018d544ff2d200048ec344776786396c.svg","dateLastActive":"2023-06-06T21:46:45+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":64108,"lastUser":{"userID":64108,"name":"krishnadbr","url":"https:\/\/community.anaplan.com\/profile\/krishnadbr","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/64108.png","dateLastActive":"2023-06-07T07:22:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3372200888,"url":"https:\/\/community.anaplan.com\/discussion\/155889\/had-l2s3-erased-and-then-recovered-now-issue-with-all-inventory-numbers-showing-0","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155889\/had-l2s3-erased-and-then-recovered-now-issue-with-all-inventory-numbers-showing-0","format":"Rich2","lastPost":{"discussionID":155889,"commentID":158409,"name":"Re: Had L2S3 erased and then recovered now issue with all inventory numbers showing 0","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158409#Comment_158409","dateInserted":"2023-06-07T05:27:00+00:00","insertUserID":64108,"insertUser":{"userID":64108,"name":"krishnadbr","url":"https:\/\/community.anaplan.com\/profile\/krishnadbr","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/64108.png","dateLastActive":"2023-06-07T07:22:07+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T05:27:00+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155887,"type":"question","name":"3.4.3 Activity: Create Country Summary Module","excerpt":"I have created the module as requested and added below formula, however there is no data reflecting in my INV02. Can anyone suggest where i am going wrong? SYS08 module snip INV02 module formula INV01 snip where my stockcount is shown as 0 completely. INV02 is shown as 0, not sure of error. Kindly let me know, thanks for…","categoryID":19,"dateInserted":"2023-06-06T19:41:23+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T03:27:57+00:00","insertUserID":111534,"insertUser":{"userID":111534,"name":"Smuti","url":"https:\/\/community.anaplan.com\/profile\/Smuti","photoUrl":"https:\/\/w9.vanillicon.com\/v2\/9d5dc2e4b24f8bebc0fc5d8301624714.svg","dateLastActive":"2023-06-06T19:56:12+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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":3372189560,"url":"https:\/\/community.anaplan.com\/discussion\/155887\/3-4-3-activity-create-country-summary-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155887\/3-4-3-activity-create-country-summary-module","format":"Rich2","lastPost":{"discussionID":155887,"commentID":158407,"name":"Re: 3.4.3 Activity: Create Country Summary Module","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158407#Comment_158407","dateInserted":"2023-06-07T03:27:57+00:00","insertUserID":91665,"insertUser":{"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-07T08:30:34+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/Q7J68MPDUXXS\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-07T03:27:57+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155885,"type":"question","name":"Training procedure","excerpt":"I m confused to understand the method of training as till now portal is only updated with written content . Will we get video session or this is only content with which we have to move on .","categoryID":182,"dateInserted":"2023-06-06T16:05:28+00:00","dateUpdated":"2023-06-06T16:06:21+00:00","dateLastComment":"2023-06-06T22:09:33+00:00","insertUserID":113205,"insertUser":{"userID":113205,"name":"VK3105","url":"https:\/\/community.anaplan.com\/profile\/VK3105","photoUrl":"https:\/\/w7.vanillicon.com\/v2\/70b349ddec0ade7760b0fc937ece652a.svg","dateLastActive":"2023-06-06T16:18:42+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":113205,"lastUserID":8014,"lastUser":{"userID":8014,"name":"Tiffany.Rice","url":"https:\/\/community.anaplan.com\/profile\/Tiffany.Rice","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8014.png","dateLastActive":"2023-06-06T22:07:01+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3372157501,"url":"https:\/\/community.anaplan.com\/discussion\/155885\/training-procedure","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155885\/training-procedure","format":"Rich2","lastPost":{"discussionID":155885,"commentID":158404,"name":"Re: Training procedure","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158404#Comment_158404","dateInserted":"2023-06-06T22:09:33+00:00","insertUserID":8014,"insertUser":{"userID":8014,"name":"Tiffany.Rice","url":"https:\/\/community.anaplan.com\/profile\/Tiffany.Rice","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8014.png","dateLastActive":"2023-06-06T22:07:01+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Academy","url":"https:\/\/community.anaplan.com\/categories\/academy"},{"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-06T22:09:33+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155875,"type":"question","name":"Can Data Hub hold formula related data? or just the spoke model is supposed to that?","excerpt":"","categoryID":19,"dateInserted":"2023-06-05T17:30:50+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T20:34:07+00:00","insertUserID":105609,"insertUser":{"userID":105609,"name":"shlokhan","url":"https:\/\/community.anaplan.com\/profile\/shlokhan","photoUrl":"https:\/\/w6.vanillicon.com\/v2\/682ef7bc9427273dbde14d950490417b.svg","dateLastActive":"2023-06-06T20:33:07+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":105609,"lastUser":{"userID":105609,"name":"shlokhan","url":"https:\/\/community.anaplan.com\/profile\/shlokhan","photoUrl":"https:\/\/w6.vanillicon.com\/v2\/682ef7bc9427273dbde14d950490417b.svg","dateLastActive":"2023-06-06T20:33:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3372071097,"url":"https:\/\/community.anaplan.com\/discussion\/155875\/can-data-hub-hold-formula-related-data-or-just-the-spoke-model-is-supposed-to-that","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155875\/can-data-hub-hold-formula-related-data-or-just-the-spoke-model-is-supposed-to-that","format":"Rich2","tagIDs":[461,1108,1111],"lastPost":{"discussionID":155875,"commentID":158400,"name":"Re: Can Data Hub hold formula related data? or just the spoke model is supposed to that?","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158400#Comment_158400","dateInserted":"2023-06-06T20:34:07+00:00","insertUserID":105609,"insertUser":{"userID":105609,"name":"shlokhan","url":"https:\/\/community.anaplan.com\/profile\/shlokhan","photoUrl":"https:\/\/w6.vanillicon.com\/v2\/682ef7bc9427273dbde14d950490417b.svg","dateLastActive":"2023-06-06T20:33:07+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-05T17:41:26+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[{"tagID":461,"urlcode":"Data","name":"Data"},{"tagID":1108,"urlcode":"data-hub","name":"Data Hub"},{"tagID":1111,"urlcode":"anaplan-community","name":"Anaplan Community"}]},{"discussionID":155877,"type":"question","name":"Variance Report Issue","excerpt":"Hi All, I am creating a variance report using a custom list mapping to a native list in order to bring the data to the module with fake list. After I sum it I noticed the Actuals data is not flowing in the actuals for the target module but in one of the version only, And other versions afre not flowing to the target…","categoryID":19,"dateInserted":"2023-06-05T23:18:13+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T17:29:15+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-07T06:36:51+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-07T06:36:51+00:00","banned":0,"punished":0,"private":true,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":37,"score":null,"hot":3372081448,"url":"https:\/\/community.anaplan.com\/discussion\/155877\/variance-report-issue","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155877\/variance-report-issue","format":"Rich2","lastPost":{"discussionID":155877,"commentID":158395,"name":"Re: Variance Report Issue","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158395#Comment_158395","dateInserted":"2023-06-06T17:29:15+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-07T06:36:51+00:00","banned":0,"punished":0,"private":true,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/6CUTZF66U5L1\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-06T07:33:23+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":155803,"type":"question","name":"assets & Predictive Insight Modelsin anaplan","excerpt":"Where can we sue this option of Assets and predective insight models in anaplan","categoryID":19,"dateInserted":"2023-05-26T10:33:02+00:00","dateUpdated":"2023-05-26T11:57:11+00:00","dateLastComment":"2023-06-06T08:00:07+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-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":78982,"lastUserID":78982,"lastUser":{"userID":78982,"name":"kishoreanimi","url":"https:\/\/community.anaplan.com\/profile\/kishoreanimi","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/78982.png","dateLastActive":"2023-06-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":33,"score":null,"hot":3371136789,"url":"https:\/\/community.anaplan.com\/discussion\/155803\/assets-predictive-insight-modelsin-anaplan","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155803\/assets-predictive-insight-modelsin-anaplan","format":"Rich2","lastPost":{"discussionID":155803,"commentID":158390,"name":"Re: assets & Predictive Insight Modelsin anaplan","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158390#Comment_158390","dateInserted":"2023-06-06T08:00:07+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-07T06:02:56+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-06T08:00:07+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[]},{"discussionID":152560,"type":"question","name":"Sprint 3 3.3.5.2C Purchase Order Line Items - Confirmed PO Delivery","excerpt":"Hi, When i am testing submit purchase order request for Cookie Crumbs_EN. In Week 9 FY20, select the Boolean for Submit Purchase Order Request? Comitted PO delivery should be enabled for Week 13, instead it is enabling for week 5 Please find the formulas i have added below, don't know where i made a mistake, sharing all…","categoryID":18,"dateInserted":"2022-11-19T03:27:46+00:00","dateUpdated":"2022-11-19T00:00:00+00:00","dateLastComment":"2023-06-06T02:18:03+00:00","insertUserID":92379,"insertUser":{"userID":92379,"name":"SrikarAllena","url":"https:\/\/community.anaplan.com\/profile\/SrikarAllena","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/92379.png","dateLastActive":"2022-11-22T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":111180,"lastUser":{"userID":111180,"name":"PeterYH","url":"https:\/\/community.anaplan.com\/profile\/PeterYH","photoUrl":"https:\/\/w3.vanillicon.com\/v2\/3b908cba8aa15abee378d90c0ab0676b.svg","dateLastActive":"2023-06-07T07:27:57+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":439,"score":null,"hot":3354846949,"url":"https:\/\/community.anaplan.com\/discussion\/152560\/sprint-3-3-3-5-2c-purchase-order-line-items-confirmed-po-delivery","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/152560\/sprint-3-3-3-5-2c-purchase-order-line-items-confirmed-po-delivery","format":"Html","tagIDs":[52,59,1123],"lastPost":{"discussionID":152560,"commentID":158381,"name":"Re: Sprint 3 3.3.5.2C Purchase Order Line Items - Confirmed PO Delivery","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158381#Comment_158381","dateInserted":"2023-06-06T02:18:03+00:00","insertUserID":111180,"insertUser":{"userID":111180,"name":"PeterYH","url":"https:\/\/community.anaplan.com\/profile\/PeterYH","photoUrl":"https:\/\/w3.vanillicon.com\/v2\/3b908cba8aa15abee378d90c0ab0676b.svg","dateLastActive":"2023-06-07T07:27:57+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"User Experience","url":"https:\/\/community.anaplan.com\/categories\/user-experience-discussions"}],"groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/SrikarAllena_2-1668856797667_152560.png?medium\/strip-exif-data\/true?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SrikarAllena_2-1668856797667.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-06T02:18:03+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":18,"name":"User Experience","url":"https:\/\/community.anaplan.com\/categories\/user-experience-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":59,"urlcode":"Anaplan-Home","name":"Anaplan Home"},{"tagID":1123,"urlcode":"user-experience","name":"User Experience"}]},{"discussionID":83667,"type":"question","name":"Excel Add-in login Issue","excerpt":"Hello All, Our users are having SSO access to Anaplan, but we are getting a non-sso login page while log-in into the Excel-add-in. We already tried to uninstall\/install the package a few times and we follow the same installation procedure for all the users. Only 3 users are facing this problem and they were able to log in…","categoryID":21,"dateInserted":"2020-09-11T07:14:20+00:00","dateUpdated":null,"dateLastComment":"2023-06-05T14:00:00+00:00","insertUserID":11770,"insertUser":{"userID":11770,"name":"VIGNESH.M","url":"https:\/\/community.anaplan.com\/profile\/VIGNESH.M","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/11770.jpeg","dateLastActive":"2023-02-17T22:10:06+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":113637,"lastUser":{"userID":113637,"name":"nicolasdevivies","url":"https:\/\/community.anaplan.com\/profile\/nicolasdevivies","photoUrl":"https:\/\/wd.vanillicon.com\/v2\/d04af07dad0155ebdd7e69e7aeea4cd4.svg","dateLastActive":"2023-06-05T14:08:05+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":35,"score":null,"hot":3285784460,"url":"https:\/\/community.anaplan.com\/discussion\/83667\/excel-add-in-login-issue","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/83667\/excel-add-in-login-issue","format":"html","tagIDs":[24,1118],"lastPost":{"discussionID":83667,"commentID":158323,"name":"Re: Excel Add-in login Issue","url":"https:\/\/community.anaplan.com\/discussion\/comment\/158323#Comment_158323","dateInserted":"2023-06-05T14:00:00+00:00","insertUserID":113637,"insertUser":{"userID":113637,"name":"nicolasdevivies","url":"https:\/\/community.anaplan.com\/profile\/nicolasdevivies","photoUrl":"https:\/\/wd.vanillicon.com\/v2\/d04af07dad0155ebdd7e69e7aeea4cd4.svg","dateLastActive":"2023-06-05T14:08:05+00:00","banned":0,"punished":0,"private":false,"label":""}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.anaplan.com\/"},{"name":"Anaplan platform discussions","url":"https:\/\/community.anaplan.com\/categories\/platform-discussions"},{"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions"}],"groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-09-11T07:34:27+00:00","acceptedAnswers":[]}},"status":{"statusID":2,"name":"Answered","state":"open","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"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}],"tags":[{"tagID":24,"urlcode":"Extensions","name":"Extensions"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}]}],"title":null,"subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}}],"defaultTabIndex":0}">
