计算功能

"},"updateUserID":75258,"lastUserID":75258,"lastUser":{"userID":75258,"name":"GingerAnderson","url":"https:\/\/community.anaplan.com\/profile\/GingerAnderson","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/75258.png","dateLastActive":"2023-06-09T22:02:11+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":378,"score":14,"hot":3329962553,"url":"https:\/\/community.anaplan.com\/discussion\/130972\/introducing-the-optimizer-toolbox","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/130972\/introducing-the-optimizer-toolbox","format":"rich2","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/samaplan_0-1643317277164_130972.png?large?v=v2&px=999","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Find module T1.1 under the Drawer 1 heading in the Modules pane"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":215,"urlcode":"Intelligence","name":"Intelligence"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":90911,"type":"idea","name":"Dynamic Cells Calculation (DCC)","excerpt":" This feature would allow to selectively switch between \"Calculation\" or \"Manual Input\" on a specific LineItem. Much like the DCA, the DCC would be based on a boolean. When True, the formula would apply but when False the user would be allowed to type data. This would allow to make Anaplan much more dynamic and greatly…","categoryID":132,"dateInserted":"2020-11-15T04:31:43+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T06:54:44+00:00","insertUserID":7776,"insertUser":{"userID":7776,"name":"damien.bouquier","url":"https:\/\/community.anaplan.com\/profile\/damien.bouquier","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/7776.jpeg","dateLastActive":"2023-05-19T12:06:15+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"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-09T14:36:30+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":23,"countViews":174,"score":74,"hot":3291744387,"url":"https:\/\/community.anaplan.com\/discussion\/90911\/dynamic-cells-calculation-dcc","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/90911\/dynamic-cells-calculation-dcc","format":"html","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":132,"name":"Modeling Ideas","url":"https:\/\/community.anaplan.com\/categories\/Modeling-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155905,"type":"question","name":"How to pull previous year end balances into a monthly calc","excerpt":"Hi So I am having a bit of an issue I need to do a calculation monthly, but I need to refer back to the previous year end balances as my start point for all months. I tried doing it with offset, why I take a starting balance for that month, and then offset everything back to December to lookup the amount needed in my calc,…","categoryID":19,"dateInserted":"2023-06-07T20:37:14+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T06:26:41+00:00","insertUserID":24736,"insertUser":{"userID":24736,"name":"alismith","url":"https:\/\/community.anaplan.com\/profile\/alismith","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/24736.png","dateLastActive":"2023-06-09T14:32:22+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":80604,"lastUser":{"userID":80604,"name":"Venki9902","url":"https:\/\/community.anaplan.com\/profile\/Venki9902","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/D83ETBO0T865\/nLLLBBE4TYQ6D.JPG","dateLastActive":"2023-06-09T12:12:01+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":30,"score":null,"hot":3372464635,"url":"https:\/\/community.anaplan.com\/discussion\/155905\/how-to-pull-previous-year-end-balances-into-a-monthly-calc","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155905\/how-to-pull-previous-year-end-balances-into-a-monthly-calc","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/1R1V83D7P3TX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-08T08:41:12+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":146044,"type":"idea","name":"Apps > Report: Add Variance between rows","excerpt":"The new feature in Apps > Report to add variance between columns (as shows in the screenshot) is fantastic. It would be very useful to have the same feature to calculate variances between rows, but this is currently unavailable. It would be greatly appreciated if this feature could please be added as soon as possible so we…","categoryID":132,"dateInserted":"2022-09-01T00:05:22+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T09:35:34+00:00","insertUserID":76313,"insertUser":{"userID":76313,"name":"JordanSFR","url":"https:\/\/community.anaplan.com\/profile\/JordanSFR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/76313.png","dateLastActive":"2022-10-11T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":24312,"lastUser":{"userID":24312,"name":"GideonG","url":"https:\/\/community.anaplan.com\/profile\/GideonG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/24312.jpeg","dateLastActive":"2023-06-09T10:03:43+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":6,"score":6,"hot":3348211256,"url":"https:\/\/community.anaplan.com\/discussion\/146044\/apps-report-add-variance-between-rows","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/146044\/apps-report-add-variance-between-rows","format":"html","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Anaplan_146044.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Anaplan.JPG"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":132,"name":"Modeling Ideas","url":"https:\/\/community.anaplan.com\/categories\/Modeling-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":54,"urlcode":"Training","name":"Training"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"},{"tagID":1111,"urlcode":"anaplan-community","name":"Anaplan Community"},{"tagID":1123,"urlcode":"user-experience","name":"User Experience"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155902,"type":"discussion","name":"I want Booleans as true as per below requirement","excerpt":"I have a input module in number format line item. I want Booleans as true for time(month) dimention lineitem. For Exmaple: If I give input = 1, then it should Boolean to be true for April 2020, July 2020, Oct 2020, Jan 2021, April 2021, July @2021…..etc If I give input = 2, then it should Boolean to be true for May2020,…","categoryID":167,"dateInserted":"2023-06-07T17:46:28+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T01:10:45+00:00","insertUserID":113867,"insertUser":{"userID":113867,"name":"Krishnarao","title":"Anaplan model builder","url":"https:\/\/community.anaplan.com\/profile\/Krishnarao","photoUrl":"https:\/\/wb.vanillicon.com\/v2\/bcb942a25af0174a67322f7186e9be6e.svg","dateLastActive":"2023-06-08T10:08:55+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":22448,"lastUser":{"userID":22448,"name":"Amaya","url":"https:\/\/community.anaplan.com\/profile\/Amaya","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/HSV9LKHQZWDS\/nMCDD12L3IISS.jpg","dateLastActive":"2023-06-09T05:05:35+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":3372347233,"url":"https:\/\/community.anaplan.com\/discussion\/155902\/i-want-booleans-as-true-as-per-below-requirement","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155902\/i-want-booleans-as-true-as-per-below-requirement","format":"Rich2","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":167,"name":"ディスカッション","url":"https:\/\/community.anaplan.com\/categories\/japan-discussions","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":142404,"type":"discussion","name":"3.3.5.2 Inventory Ordering Module Formulas","excerpt":"Hi, From 3.3.5.2 Inventory Ordering Module Formulas I am not getting correct output for 2 line items - Beginning inventory and shipping time weeks. Beginning Inventory - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory…","categoryID":182,"dateInserted":"2022-07-16T02:41:04+00:00","dateUpdated":null,"dateLastComment":"2023-06-07T15:21:11+00:00","insertUserID":85948,"insertUser":{"userID":85948,"name":"SupriyaH","url":"https:\/\/community.anaplan.com\/profile\/SupriyaH","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/85948.png","dateLastActive":"2023-06-08T09:55:26+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":109029,"lastUser":{"userID":109029,"name":"brianperez","url":"https:\/\/community.anaplan.com\/profile\/brianperez","photoUrl":"https:\/\/w7.vanillicon.com\/v2\/7ab1568cbc01f1e78fdc347d1bff1bee.svg","dateLastActive":"2023-06-07T17:59:08+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":338,"score":null,"hot":3344095335,"url":"https:\/\/community.anaplan.com\/discussion\/142404\/3-3-5-2-inventory-ordering-module-formulas","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/142404\/3-3-5-2-inventory-ordering-module-formulas","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/SupriyaH_0-1657964378678_142404.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SupriyaH_0-1657964378678.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":58865,"type":"question","name":"How to convert text to date","excerpt":"Hi , I have a text formatted line item which is a date .I want to convert it to Date format . I tried to break it into three Year ,Month and day using Value(RIGHT(Line item,4)) Value(Mid(Line item,4,2)) Value(LEFT(line Item,2)) It works for 12\/10\/2012 but what about 2\/3\/2012 ?? Note -- Can't change source text to date…","categoryID":19,"dateInserted":"2020-01-29T22:04:55+00:00","dateUpdated":null,"dateLastComment":"2023-06-06T23:27:24+00:00","insertUserID":10175,"insertUser":{"userID":10175,"name":"shadmani","url":"https:\/\/community.anaplan.com\/profile\/shadmani","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/10175.png","dateLastActive":"2023-04-06T09:11:59+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":31,"lastUser":{"userID":31,"name":"allen","url":"https:\/\/community.anaplan.com\/profile\/allen","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/31.png","dateLastActive":"2023-06-06T23:21:02+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":944,"score":1,"hot":3266432839,"url":"https:\/\/community.anaplan.com\/discussion\/58865\/how-to-convert-text-to-date","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/58865\/how-to-convert-text-to-date","format":"html","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-23T21:29:03+00:00","dateAnswered":"2020-01-29T23:56:19+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":36616,"type":"idea","name":"Ability to sum based on boolean","excerpt":"Description of enhancement required Ability to allow to aggregate using Boolean mapping. Currently mapping can only be applied over List elements. It would simplify many formulas if we could simply SUM\/PRODUCT over TRUE\/FALSE Boolean values. An example of enhancement - See example below *List called \"Client\" with 3 items.…","categoryID":132,"dateInserted":"2018-09-25T07:28:03+00:00","dateUpdated":null,"dateLastComment":"2023-06-05T14:54:25+00:00","insertUserID":11518,"insertUser":{"userID":11518,"name":"AnaplanIdeas","url":"https:\/\/community.anaplan.com\/profile\/AnaplanIdeas","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/11518.png","dateLastActive":"2019-08-21T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":73876,"lastUser":{"userID":73876,"name":"kosterhout","url":"https:\/\/community.anaplan.com\/profile\/kosterhout","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/73876.png","dateLastActive":"2023-06-05T14:52:59+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":529,"score":38,"hot":3223855348,"url":"https:\/\/community.anaplan.com\/discussion\/36616\/ability-to-sum-based-on-boolean","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/36616\/ability-to-sum-based-on-boolean","format":"html","groupID":null,"statusID":10005,"attributes":{"idea":{"statusNotes":null,"statusID":10005,"status":{"name":"In Review","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":132,"name":"Modeling Ideas","url":"https:\/\/community.anaplan.com\/categories\/Modeling-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1065,"urlcode":"In Review","name":"In Review"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":151418,"type":"question","name":"Performance of Comparision of Boolean using = sign over using NOT function","excerpt":"Whether using IF Approved? = TRUE THEN 1 ELSE 0 is good or optimizing the formula as IF Approved? THEN 1 ELSE 0 where \"Approved?\" is a BOOLEAN format line item. Same goes for, IF Approved? = FALSE THEN 1 ELSE 0 IF NOT Approved? THEN 1 ELSE 0 Please advise to optimize performance of the model.","categoryID":28,"dateInserted":"2022-11-07T02:24:30+00:00","dateUpdated":"2022-11-07T00:00:00+00:00","dateLastComment":"2023-06-05T08:21:20+00:00","insertUserID":90559,"insertUser":{"userID":90559,"name":"Pranjal","url":"https:\/\/community.anaplan.com\/profile\/Pranjal","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/90559.png","dateLastActive":"2023-05-15T09:28:04+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":113601,"lastUser":{"userID":113601,"name":"miltonwhite","title":"Cybersecurity & Data Protection Specialist","url":"https:\/\/community.anaplan.com\/profile\/miltonwhite","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/1O325ID4SHL2\/n6I6UQOS87SV9.jpg","dateLastActive":"2023-06-05T08:17:31+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3353742950,"url":"https:\/\/community.anaplan.com\/discussion\/151418\/performance-of-comparision-of-boolean-using-sign-over-using-not-function","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/151418\/performance-of-comparision-of-boolean-using-sign-over-using-not-function","format":"Html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-11-07T02:41:55+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":28,"name":"Security and tenant administration","url":"https:\/\/community.anaplan.com\/categories\/security-and-tenant-administration","allowedDiscussionTypes":["question"]},"tags":[{"tagID":26,"urlcode":"Security-and-Administration","name":"Security and Administration"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"},{"tagID":1125,"urlcode":"application-lifecycle-management","name":"Application Lifecycle Management"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155804,"type":"question","name":"How to add a button that creates a new line item in the GL that has a hierarchal structure","excerpt":"The current button we have in place has us add in a new SUB-GL\/ vendor item to a numbered list. That numbered list uses an OpEx subset that layers in each new vendor into its respective opex area such as adding \"Anaplan 2.1\" under Software subscriptions in the GL. The problem im running into is that this current structure…","categoryID":19,"dateInserted":"2023-05-26T14:56:53+00:00","dateUpdated":"2023-05-30T14:46:51+00:00","dateLastComment":"2023-06-02T19:55:34+00:00","insertUserID":101156,"insertUser":{"userID":101156,"name":"croufail20","url":"https:\/\/community.anaplan.com\/profile\/croufail20","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/101156.png","dateLastActive":"2023-05-30T17:39:24+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":101156,"lastUserID":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-08T15:08:39+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":42,"score":null,"hot":3370849347,"url":"https:\/\/community.anaplan.com\/discussion\/155804\/how-to-add-a-button-that-creates-a-new-line-item-in-the-gl-that-has-a-hierarchal-structure","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155804\/how-to-add-a-button-that-creates-a-new-line-item-in-the-gl-that-has-a-hierarchal-structure","format":"Rich2","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/5KQCWWYLF6KS\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-02T19:55:34+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":48,"urlcode":"Model-Builder","name":"Model Builder"},{"tagID":1092,"urlcode":"Model-Contributor","name":"Model Contributor"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155790,"type":"question","name":"Boolean with summary : \"all\", true for parent with no child?","excerpt":"Why is a Boolean line item with summary set to ALL true for Parent even when there are no child items? I noticed that a boolean line item was true for a parent in the hierarchy automatically if summary was set to ALL even if it had no children. Why is this so? I thought if summary is set to ALL the parent would be true if…","categoryID":19,"dateInserted":"2023-05-25T08:29:39+00:00","dateUpdated":"2023-05-25T12:26:39+00:00","dateLastComment":"2023-06-02T09:52:30+00:00","insertUserID":110616,"insertUser":{"userID":110616,"name":"ChaitanyaKakara","url":"https:\/\/community.anaplan.com\/profile\/ChaitanyaKakara","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/KQEQFOZ2J8OV\/n591LS9QF66BS.jpg","dateLastActive":"2023-06-02T09:50:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":110616,"lastUserID":110616,"lastUser":{"userID":110616,"name":"ChaitanyaKakara","url":"https:\/\/community.anaplan.com\/profile\/ChaitanyaKakara","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/KQEQFOZ2J8OV\/n591LS9QF66BS.jpg","dateLastActive":"2023-06-02T09:50:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":92,"score":null,"hot":3370707729,"url":"https:\/\/community.anaplan.com\/discussion\/155790\/boolean-with-summary-all-true-for-parent-with-no-child","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155790\/boolean-with-summary-all-true-for-parent-with-no-child","format":"Rich2","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-02T09:51:13+00:00","dateAnswered":"2023-06-01T18:10:55+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":59,"urlcode":"Anaplan-Home","name":"Anaplan Home"},{"tagID":719,"urlcode":"Developer","name":"Developer"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"},{"tagID":1111,"urlcode":"anaplan-community","name":"Anaplan Community"},{"tagID":1117,"urlcode":"management-reporting","name":"Management Reporting"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":33556,"type":"discussion","name":"OEG Best Practice: Formulas and their effects on model performance","excerpt":"Details of known issues Challenge Recommendations Performance issues with long nested formulas Need to have a long formula on time as a result of nested intermediate calculations. If the model size does not prevent from adding extra line items, it's a better practice to create multiple intermediate line items and reduce…","categoryID":40,"dateInserted":"2018-05-31T12:27:19+00:00","dateUpdated":"2023-02-09T17:05:35+00:00","dateLastComment":"2023-06-01T22:09:24+00:00","insertUserID":101715,"insertUser":{"userID":101715,"name":"AnaplanOEG","url":"https:\/\/community.anaplan.com\/profile\/AnaplanOEG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/AKCCM7USWMRM\/n1EGQRZGHE2WA.png","dateLastActive":"2023-02-14T17:14:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"lastUserID":365,"lastUser":{"userID":365,"name":"ryan_kohn","url":"https:\/\/community.anaplan.com\/profile\/ryan_kohn","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/365.jpeg","dateLastActive":"2023-06-09T21:44:58+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":422,"score":8,"hot":3213432403,"url":"https:\/\/community.anaplan.com\/discussion\/33556\/oeg-best-practice-formulas-and-their-effects-on-model-performance","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/33556\/oeg-best-practice-formulas-and-their-effects-on-model-performance","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"},{"tagID":1137,"urlcode":"oeg-best-practice","name":"OEG Best Practice"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":148168,"type":"discussion","name":"Level 2 Sprint 2 2.3.10","excerpt":"Hi, as a result for the first question (2.3.10) I have the answer 71.34 but it should be 73.48. I don't seem to understand where I made a mistake. Could anyone help me out please? - DEM01 screenshot 1 (DEM01) - DEM02 screenshot 2 (DEM02) - DAT03 screenshot 3 (DAT03) - Formula: IF 'SYS01 Time Settings By Week'.'1st Forecast…","categoryID":182,"dateInserted":"2022-09-30T01:54:17+00:00","dateUpdated":null,"dateLastComment":"2023-06-01T17:45:22+00:00","insertUserID":93974,"insertUser":{"userID":93974,"name":"LaurensCoene","url":"https:\/\/community.anaplan.com\/profile\/LaurensCoene","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/93974.png","dateLastActive":"2022-11-17T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":109029,"lastUser":{"userID":109029,"name":"brianperez","url":"https:\/\/community.anaplan.com\/profile\/brianperez","photoUrl":"https:\/\/w7.vanillicon.com\/v2\/7ab1568cbc01f1e78fdc347d1bff1bee.svg","dateLastActive":"2023-06-07T17:59:08+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":273,"score":1,"hot":3350146479,"url":"https:\/\/community.anaplan.com\/discussion\/148168\/level-2-sprint-2-2-3-10","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/148168\/level-2-sprint-2-2-3-10","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155830,"type":"question","name":"HiI want to use quarterly sum in another module which is in months. How to do that?","excerpt":"","categoryID":19,"dateInserted":"2023-05-31T15:13:21+00:00","dateUpdated":"2023-06-01T08:30:39+00:00","dateLastComment":"2023-06-01T08:29:55+00:00","insertUserID":94216,"insertUser":{"userID":94216,"name":"Chandrashekar1997","url":"https:\/\/community.anaplan.com\/profile\/Chandrashekar1997","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/94216.png","dateLastActive":"2023-06-07T17:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":94216,"lastUserID":94216,"lastUser":{"userID":94216,"name":"Chandrashekar1997","url":"https:\/\/community.anaplan.com\/profile\/Chandrashekar1997","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/94216.png","dateLastActive":"2023-06-07T17:06:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":41,"score":null,"hot":3371155396,"url":"https:\/\/community.anaplan.com\/discussion\/155830\/hii-want-to-use-quarterly-sum-in-another-module-which-is-in-months-how-to-do-that","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155830\/hii-want-to-use-quarterly-sum-in-another-module-which-is-in-months-how-to-do-that","format":"Rich2","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-01T08:29:25+00:00","dateAnswered":"2023-05-31T15:50:50+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":124897,"type":"question","name":"3.3.12 Activity: Create Product Replenishment UX Page - Conditional Formatting","excerpt":"Hi, For this section of Activity 3.3.12 regarding conditional formatting, I have not been able to find the rule to reflect the condition below: * Add conditional formatting to display Ending Inventory as red when the value is less than the Safety Stock Target value. See below the options I see for conditional formatting,…","categoryID":182,"dateInserted":"2021-11-15T10:30:48+00:00","dateUpdated":"2023-04-14T21:17:11+00:00","dateLastComment":"2023-05-31T16:03:53+00:00","insertUserID":55565,"insertUser":{"userID":55565,"name":"juanacevedo","url":"https:\/\/community.anaplan.com\/profile\/juanacevedo","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/55565.png","dateLastActive":"2023-05-04T19:52:04+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":365,"lastUserID":106365,"lastUser":{"userID":106365,"name":"MPWall","url":"https:\/\/community.anaplan.com\/profile\/MPWall","photoUrl":"https:\/\/w0.vanillicon.com\/v2\/018d544ff2d200048ec344776786396c.svg","dateLastActive":"2023-06-09T23:12:32+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":205,"score":null,"hot":3322524881,"url":"https:\/\/community.anaplan.com\/discussion\/124897\/3-3-12-activity-create-product-replenishment-ux-page-conditional-formatting","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/124897\/3-3-12-activity-create-product-replenishment-ux-page-conditional-formatting","format":"html","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/juanacevedo_0-1637000965563_124897.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"juanacevedo_0-1637000965563.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-11-15T21:33:30+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"},{"tagID":1123,"urlcode":"user-experience","name":"User Experience"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":76049,"type":"question","name":"Level 2 Conclusion INV05 Shipping Export","excerpt":"@Misbah Shipping Costs = 'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Distribution Center] This formula for the shipping costs line item is giving me '0' as values. Is it because the formulae I have entered is wrong?","categoryID":19,"dateInserted":"2020-07-05T23:47:12+00:00","dateUpdated":null,"dateLastComment":"2023-05-31T06:45:45+00:00","insertUserID":35129,"insertUser":{"userID":35129,"name":"Jemsheed","url":"https:\/\/community.anaplan.com\/profile\/Jemsheed","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/35129.png","dateLastActive":"2020-07-23T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":74308,"lastUser":{"userID":74308,"name":"Taswwur","url":"https:\/\/community.anaplan.com\/profile\/Taswwur","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/74308.png","dateLastActive":"2023-06-01T09:23:43+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":252,"score":null,"hot":3279510177,"url":"https:\/\/community.anaplan.com\/discussion\/76049\/level-2-conclusion-inv05-shipping-export","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/76049\/level-2-conclusion-inv05-shipping-export","format":"html","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-23T21:29:03+00:00","dateAnswered":"2020-07-06T00:03:49+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":93717,"type":"idea","name":"Today() Function","excerpt":"I'm wondering why in Anaplan we can only have to input current period in Time. As we're using Anaplan as Supply Chain planification tools and we work really at planning on days level. So it's necessary for us to determine \"today\"'s date. The solution we use now is to launch an automatic import and update the \"Today\" item.…","categoryID":132,"dateInserted":"2020-12-17T09:46:45+00:00","dateUpdated":null,"dateLastComment":"2023-05-30T22:51:35+00:00","insertUserID":15322,"insertUser":{"userID":15322,"name":"chengtian.lou","url":"https:\/\/community.anaplan.com\/profile\/chengtian.lou","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/15322.png","dateLastActive":"2023-02-08T09:39:35+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":81412,"lastUser":{"userID":81412,"name":"awestphal","url":"https:\/\/community.anaplan.com\/profile\/awestphal","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/81412.png","dateLastActive":"2023-05-30T22:51:03+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":425,"score":81,"hot":3293717000,"url":"https:\/\/community.anaplan.com\/discussion\/93717\/today-function","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/93717\/today-function","format":"html","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":132,"name":"Modeling Ideas","url":"https:\/\/community.anaplan.com\/categories\/Modeling-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":46768,"type":"question","name":"Calcuation of subsets as my allocation basis","excerpt":"Hi guys, how can i get the totals of my subsets in my formula so the totals of my denominator will only be the totals of the subsets? Thanks in advance.","categoryID":19,"dateInserted":"2019-06-05T20:26:23+00:00","dateUpdated":null,"dateLastComment":"2023-05-29T22:39:08+00:00","insertUserID":15203,"insertUser":{"userID":15203,"name":"elaine.novel","url":"https:\/\/community.anaplan.com\/profile\/elaine.novel","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/15203.png","dateLastActive":"2023-06-01T07:49:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":99729,"lastUser":{"userID":99729,"name":"SantoshPadhi","url":"https:\/\/community.anaplan.com\/profile\/SantoshPadhi","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/99729.png","dateLastActive":"2023-06-06T14:55:32+00:00","banned":0,"punished":0,"private":true,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":54,"score":null,"hot":3245168131,"url":"https:\/\/community.anaplan.com\/discussion\/46768\/calcuation-of-subsets-as-my-allocation-basis","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/46768\/calcuation-of-subsets-as-my-allocation-basis","format":"html","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-23T21:29:03+00:00","dateAnswered":"2019-06-05T21:28:52+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":83698,"type":"question","name":"Update Historic Volumes for Baseline Forecast","excerpt":"Hi Im trying to build the volumes for baseline forecast and below is my formula resulting in the following error IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast…","categoryID":19,"dateInserted":"2020-09-11T09:47:28+00:00","dateUpdated":null,"dateLastComment":"2023-05-28T09:25:18+00:00","insertUserID":39298,"insertUser":{"userID":39298,"name":"rmat066sysf","url":"https:\/\/community.anaplan.com\/profile\/rmat066sysf","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/39298.png","dateLastActive":"2022-04-23T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":110180,"lastUser":{"userID":110180,"name":"AnnaYalovva","url":"https:\/\/community.anaplan.com\/profile\/AnnaYalovva","photoUrl":"https:\/\/w5.vanillicon.com\/v2\/5089f79336a478e1ee8ab0cbd2be6817.svg","dateLastActive":"2023-05-28T18:56:18+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":22,"score":null,"hot":3285085966,"url":"https:\/\/community.anaplan.com\/discussion\/83698\/update-historic-volumes-for-baseline-forecast","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/83698\/update-historic-volumes-for-baseline-forecast","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-09-11T12:19:03+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"},{"tagID":1123,"urlcode":"user-experience","name":"User Experience"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":91668,"type":"idea","name":"IRR function to operate on a specified time period ranges","excerpt":"Hello team I would propose an idea of IRR function enhancement to operate on more dynamic environment and respect Anaplan time dimension in the same way as TIMESUM function. Why it is necessary? For IRR calculation when the sign of the cash flows changes more than once, for example when positive cash flows are followed by…","categoryID":132,"dateInserted":"2020-11-23T02:43:13+00:00","dateUpdated":null,"dateLastComment":"2023-05-24T02:27:19+00:00","insertUserID":568,"insertUser":{"userID":568,"name":"nikolay_denisov","url":"https:\/\/community.anaplan.com\/profile\/nikolay_denisov","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/568.jpeg","dateLastActive":"2023-06-01T21:33:46+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":3039,"lastUser":{"userID":3039,"name":"Paul_Petersen","url":"https:\/\/community.anaplan.com\/profile\/Paul_Petersen","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3039.jpeg","dateLastActive":"2023-06-02T00:50:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":85,"score":29,"hot":3291009332,"url":"https:\/\/community.anaplan.com\/discussion\/91668\/irr-function-to-operate-on-a-specified-time-period-ranges","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/91668\/irr-function-to-operate-on-a-specified-time-period-ranges","format":"html","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":132,"name":"Modeling Ideas","url":"https:\/\/community.anaplan.com\/categories\/Modeling-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":113402,"type":"question","name":"Level2 Sprint3 3.3.5.3 Check Your Work","excerpt":"Hello all, After inserting the formulas to INV01, my numbers aren't exactly the same as the screenshot on the instruction. Where I might've made mistakes? This is my blueprint view: ","categoryID":19,"dateInserted":"2021-07-06T04:44:14+00:00","dateUpdated":null,"dateLastComment":"2023-05-23T19:22:50+00:00","insertUserID":39033,"insertUser":{"userID":39033,"name":"zolzaya","url":"https:\/\/community.anaplan.com\/profile\/zolzaya","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/39033.png","dateLastActive":"2021-07-21T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":96287,"lastUser":{"userID":96287,"name":"ChristopherM","url":"https:\/\/community.anaplan.com\/profile\/ChristopherM","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/96287.png","dateLastActive":"2023-06-08T23:10:24+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":13,"score":null,"hot":3310418224,"url":"https:\/\/community.anaplan.com\/discussion\/113402\/level2-sprint3-3-3-5-3-check-your-work","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/113402\/level2-sprint3-3-3-5-3-check-your-work","format":"html","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/zolzaya_0-1625571801356_113402.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"zolzaya_0-1625571801356.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-23T21:29:03+00:00","dateAnswered":"2021-07-06T14:39:44+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":140709,"type":"discussion","name":"OEG Best Practice: Anaplan Performance Triangle","excerpt":"Building well performing models is a balance between the complexity and functionality of a model versus the number of concurrent users. If you have seen software development \/ project management triangles, where scope, time and cost control quality, this will be familiar. It is a good way to show the constraints of any…","categoryID":40,"dateInserted":"2022-07-13T07:07:29+00:00","dateUpdated":"2023-05-23T18:08:45+00:00","dateLastComment":"2023-05-23T18:05:44+00:00","insertUserID":101715,"insertUser":{"userID":101715,"name":"AnaplanOEG","url":"https:\/\/community.anaplan.com\/profile\/AnaplanOEG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/AKCCM7USWMRM\/n1EGQRZGHE2WA.png","dateLastActive":"2023-02-14T17:14:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":75258,"lastUserID":19357,"lastUser":{"userID":19357,"name":"bhill5","url":"https:\/\/community.anaplan.com\/profile\/bhill5","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/19357.jpeg","dateLastActive":"2023-06-09T15:39:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":284,"score":19,"hot":3342568093,"url":"https:\/\/community.anaplan.com\/discussion\/140709\/oeg-best-practice-anaplan-performance-triangle","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/140709\/oeg-best-practice-anaplan-performance-triangle","format":"rich2","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/MarkWarren_0-1656416998337_140709.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"MarkWarren_0-1656416998337.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"},{"tagID":1137,"urlcode":"oeg-best-practice","name":"OEG Best Practice"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":138215,"type":"discussion","name":"12.4.2 Create Saved View for Country Margin Report","excerpt":"Hi, I'm working on Lesson 12 in Level one. My issue is that the example data is slightly different from what I've been building so far. I'm not sure if it's the format or formula from the other modules. Please send suggestions","categoryID":182,"dateInserted":"2022-05-19T19:09:40+00:00","dateUpdated":null,"dateLastComment":"2023-05-23T16:33:04+00:00","insertUserID":84094,"insertUser":{"userID":84094,"name":"Hollisj12","url":"https:\/\/community.anaplan.com\/profile\/Hollisj12","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/84094.png","dateLastActive":"2022-07-20T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":107412,"lastUser":{"userID":107412,"name":"Flame","url":"https:\/\/community.anaplan.com\/profile\/Flame","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/OWO14OOHFZF1\/nMOF5NROAHVNB.jpg","dateLastActive":"2023-06-09T17:08:43+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":42,"score":null,"hot":3337849964,"url":"https:\/\/community.anaplan.com\/discussion\/138215\/12-4-2-create-saved-view-for-country-margin-report","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/138215\/12-4-2-create-saved-view-for-country-margin-report","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":139653,"type":"discussion","name":"12.4.3 Activity: Create Saved Views for Size Margin Report - ***Numbers are off***","excerpt":"I can not seem to understand why my numbers are off. Please help, I have been staring at this for 2 hours","categoryID":182,"dateInserted":"2022-06-12T16:17:25+00:00","dateUpdated":null,"dateLastComment":"2023-05-23T16:05:26+00:00","insertUserID":78847,"insertUser":{"userID":78847,"name":"Jona","url":"https:\/\/community.anaplan.com\/profile\/Jona","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/78847.png","dateLastActive":"2023-02-23T05:11:56+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":107412,"lastUser":{"userID":107412,"name":"Flame","url":"https:\/\/community.anaplan.com\/profile\/Flame","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/OWO14OOHFZF1\/nMOF5NROAHVNB.jpg","dateLastActive":"2023-06-09T17:08:43+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":21,"score":null,"hot":3339910971,"url":"https:\/\/community.anaplan.com\/discussion\/139653\/12-4-3-activity-create-saved-views-for-size-margin-report-numbers-are-off","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/139653\/12-4-3-activity-create-saved-views-for-size-margin-report-numbers-are-off","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":873,"type":"question","name":"How to refer a properties in formulas","excerpt":"Hi, How can we refer properties in formula","categoryID":19,"dateInserted":"2016-06-16T14:26:28+00:00","dateUpdated":null,"dateLastComment":"2023-05-23T00:26:43+00:00","insertUserID":8,"insertUser":{"userID":8,"name":"PrevContributor","url":"https:\/\/community.anaplan.com\/profile\/PrevContributor","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8.png","dateLastActive":"2017-10-10T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":72041,"lastUser":{"userID":72041,"name":"Livy","url":"https:\/\/community.anaplan.com\/profile\/Livy","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/72041.png","dateLastActive":"2023-05-25T05:56:36+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":188,"score":null,"hot":3150891191,"url":"https:\/\/community.anaplan.com\/discussion\/873\/how-to-refer-a-properties-in-formulas","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/873\/how-to-refer-a-properties-in-formulas","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2016-06-16T14:42:48+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":80678,"type":"idea","name":"Create a Formula to Reference a User's Model Role","excerpt":"Dynamic cell access can be extremely challenging with long user lists, especially if you want a user's read\/write abilities to be dependent on their model role. If we were able to reference a user's model role via a formula, we could create role specific criteria for dynamic cell access.","categoryID":133,"dateInserted":"2020-08-18T10:35:41+00:00","dateUpdated":null,"dateLastComment":"2023-05-22T17:51:22+00:00","insertUserID":3094,"insertUser":{"userID":3094,"name":"rachel_goering","url":"https:\/\/community.anaplan.com\/profile\/rachel_goering","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3094.jpeg","dateLastActive":"2022-10-05T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":18935,"lastUser":{"userID":18935,"name":"jepley","url":"https:\/\/community.anaplan.com\/profile\/jepley","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/18935.jpeg","dateLastActive":"2023-06-09T20:41:39+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":18,"countViews":265,"score":98,"hot":3282565023,"url":"https:\/\/community.anaplan.com\/discussion\/80678\/create-a-formula-to-reference-a-users-model-role","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/80678\/create-a-formula-to-reference-a-users-model-role","format":"html","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":133,"name":"Security and Tenant Administration Ideas","url":"https:\/\/community.anaplan.com\/categories\/security-and-tenant-administration-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":26,"urlcode":"Security-and-Administration","name":"Security and Administration"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155714,"type":"question","name":"Date Line Item using Min Summary","excerpt":"Hello I am using line item formatted as date with 6 level hierarchy. I am using summary as Min for the same. I am facing issues where if there is no date in my list P6, i am getting 12\/31\/2399 for all NonBlank list members. Please advise best way to handle it without doing any hardcoding. Regards MO","categoryID":19,"dateInserted":"2023-05-16T22:26:56+00:00","dateUpdated":null,"dateLastComment":"2023-05-18T14:31:27+00:00","insertUserID":14147,"insertUser":{"userID":14147,"name":"mohitohri1811","url":"https:\/\/community.anaplan.com\/profile\/mohitohri1811","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14147.png","dateLastActive":"2023-05-24T22:05:19+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":14147,"lastUser":{"userID":14147,"name":"mohitohri1811","url":"https:\/\/community.anaplan.com\/profile\/mohitohri1811","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14147.png","dateLastActive":"2023-05-24T22:05:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":61,"score":null,"hot":3368699903,"url":"https:\/\/community.anaplan.com\/discussion\/155714\/date-line-item-using-min-summary","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155714\/date-line-item-using-min-summary","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-05-17T12:00:10+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":719,"urlcode":"Developer","name":"Developer"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"},{"tagID":1111,"urlcode":"anaplan-community","name":"Anaplan Community"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":40198,"type":"idea","name":"Ability to select versions as a list formatted line item for use in lookup statements","excerpt":"Versions are useful as they allow switchover functionality enabling a user to both enter a forecast on a line and see actuals in the same line item. However, comparing versions to eachother (any version to any other version dynamically) requires a \"Versions List\" and logic to engage that list with the Version you want to…","categoryID":132,"dateInserted":"2019-01-14T14:12:10+00:00","dateUpdated":null,"dateLastComment":"2023-05-16T07:13:20+00:00","insertUserID":2257,"insertUser":{"userID":2257,"name":"ron_baylo","url":"https:\/\/community.anaplan.com\/profile\/ron_baylo","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/2257.png","dateLastActive":"2019-04-17T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":3139,"lastUser":{"userID":3139,"name":"Sukh_Sandhu","url":"https:\/\/community.anaplan.com\/profile\/Sukh_Sandhu","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3139.jpeg","dateLastActive":"2023-06-01T17:17:24+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":24,"countViews":186,"score":163,"hot":3231759630,"url":"https:\/\/community.anaplan.com\/discussion\/40198\/ability-to-select-versions-as-a-list-formatted-line-item-for-use-in-lookup-statements","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/40198\/ability-to-select-versions-as-a-list-formatted-line-item-for-use-in-lookup-statements","format":"html","groupID":null,"statusID":10005,"attributes":{"idea":{"statusNotes":null,"statusID":10005,"status":{"name":"In Review","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":132,"name":"Modeling Ideas","url":"https:\/\/community.anaplan.com\/categories\/Modeling-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1065,"urlcode":"In Review","name":"In Review"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":84257,"type":"question","name":"Level 1 Lesson 11.3.4 Activity: Add Formulas to Profit and Loss Report Module","excerpt":"Hi I have a problem in fixing the formulas for the above lesson. I have attached the screen shots for the first formula I was supposed to create which is for Headcount. REP03 Profit & Loss Headcount FormulaError message displayed for the formula Further, I would like to know whether the formula repeats itself for all the…","categoryID":19,"dateInserted":"2020-09-17T00:26:58+00:00","dateUpdated":null,"dateLastComment":"2023-05-16T05:02:05+00:00","insertUserID":39075,"insertUser":{"userID":39075,"name":"ThiruT","url":"https:\/\/community.anaplan.com\/profile\/ThiruT","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/39075.jpeg","dateLastActive":"2021-03-08T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":110807,"lastUser":{"userID":110807,"name":"bogirere","url":"https:\/\/community.anaplan.com\/profile\/bogirere","photoUrl":"https:\/\/w2.vanillicon.com\/v2\/2a3be00acf0851ed0f511aa5f062f9d2.svg","dateLastActive":"2023-06-09T04:38:26+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":51,"score":null,"hot":3284518143,"url":"https:\/\/community.anaplan.com\/discussion\/84257\/level-1-lesson-11-3-4-activity-add-formulas-to-profit-and-loss-report-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/84257\/level-1-lesson-11-3-4-activity-add-formulas-to-profit-and-loss-report-module","format":"html","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/REP03_Profit_and_Loss_Headcount_Formula_84257.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"REP03 Profit & Loss Headcount Formula"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-09-17T02:37:26+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":126332,"type":"discussion","name":"L2 Conclusion - REP05 Local Currency","excerpt":" Is there any issue with the formula for Local Currency? - Although it's fetching the correct result, want to check if there is anything else I'm missing. regards Sudhir","categoryID":182,"dateInserted":"2021-12-05T09:16:22+00:00","dateUpdated":null,"dateLastComment":"2023-05-12T13:30:54+00:00","insertUserID":34169,"insertUser":{"userID":34169,"name":"SudhirY","url":"https:\/\/community.anaplan.com\/profile\/SudhirY","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/34169.jpeg","dateLastActive":"2023-04-04T06:14:36+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":108094,"lastUser":{"userID":108094,"name":"Hvbarata","url":"https:\/\/community.anaplan.com\/profile\/Hvbarata","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/908UVBRR3TD3\/n4WNC0FBSOYUP.jpg","dateLastActive":"2023-05-12T15:33:16+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":595,"score":null,"hot":3322598236,"url":"https:\/\/community.anaplan.com\/discussion\/126332\/l2-conclusion-rep05-local-currency","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/126332\/l2-conclusion-rep05-local-currency","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/SudhirY_0-1638724440444_126332.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"SudhirY_0-1638724440444.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">