Register
Ask the Community

About Kyle

since ‎03-20-2017
‎12-17-2021
Kyle
Contributor
Activity Feed for Kyle
Group Hubs for Kyle
View All

Re: Date function

byContributorinAnaplan Platform
‎05-03-201707:33 AM
3 Kudos
‎05-03-201707:33 AM
3 Kudos
Hi Prabakaran, You have to put apostrophes around the Report Date (Date) line item because of the parenthesis. Attached is a screenshot to show the formula. I hope this helps! Kyle ... View more

Re: Date function

byContributorinAnaplan Platform
‎04-28-201708:39 AM
‎04-28-201708:39 AM
Hi Prabakaran, Your approach sounds appropriate to me. You can use a combination of the LEFT and RIGHT functions to convert the text into the format necessary to then use the VALUE function to convert the text into numbers that can then be used as input into the DATE function. I recommend using multiple line items for testing purposes and then you can consolidate them into a single line item later. I hope this helps! Kyle ... View more

Re: Can you change a numbered list back to a non-n...

byContributorinAnaplan Platform
‎04-27-201710:49 AM
2 Kudos
‎04-27-201710:49 AM
2 Kudos
Hi Tim, If it does not affect users, you could restore to ID. Can also take the model offline, revert to history and export what the list is, and then reupload the list after reverting to the current state. I hope this helps! Kyle ... View more

Re: How to put formula in one list item and keep b...

byContributorinAnaplan Platform
‎04-26-201710:59 AM
‎04-26-201710:59 AM
Hi Maki, There is no way to have a line item be editable for some situations and be a formula for others except using formula scope which relies on version. For a list, you would have to have multiple line items where one would be an input and then another that has a formula that for Item A does what you would like it to, and for Item B, grabs the value from the first line item. You can use the ITEM function to help with specifying which items are applicable for different parts of the formula. I hope this helps! Best, Kyle ... View more

Re: Help with NPV Function: Anaplan differing from...

byContributorinAnaplan Platform
‎04-25-201703:22 PM
‎04-25-201703:22 PM
Hello, If this is a one time formula that doesn't need to adjust, then you could use an if statement similar to IF ITEM(Time) > TIME.'Q2 FY18' THEN ... or you could setup a line item that provides an adjusting criteria for the if statement. I hope this helps! Kyle ... View more

Re: Formula for Range of value

byContributorinSan Francisco Forum
‎04-06-201702:29 PM
‎04-06-201702:29 PM
Hi Prabakaran, It's difficult to say without looking at the lists and blueprints, but one thing you could do is add a property to the asset listthat checks to see if the asset is greater than 4 years old. Then in the module that has the values you would like to sum, add a line item that says if the greater than 4 years old property is true, then take the value else 0. Then in the planning module, you could use a select function to grab the top level of the asset list from the >4 year old line item you created which would only contain the >4 year old values. The last formula would look like Module Name.'Greater than 4 Year Old Line Item Name'[select: asset list.Top Level Item]. Let me know if this helps at all. Best, Kyle ... View more

Re: Formula for blank value in lookup function

byContributorinAnaplan Platform
‎04-05-201701:42 PM
3 Kudos
‎04-05-201701:42 PM
3 Kudos
你好,如果开放数量是格式化的,then you would have to write IF Open Qty by Bucket ID.Open Qty[LOOKUP: Bucket ID LF, LOOKUP: SKU LF] = 0 THEN Quantity Reqd ELSE Open Qty by Bucket ID.Open Qty[LOOKUP: Bucket ID LF, LOOKUP: SKU LF] because the 'BLANK' statement is for text, time, date or list formatted line items. If the issue that is causing the blanks is because the 'Bucket ID LF' or 'SKU LF' line items aren't always populated, then you could do IF ISBLANK(Bucket ID LF) OR ISBLANK(SKU LF) THEN Quantity Reqd ELSE Open Qty by Bucket ID.Open Qty[LOOKUP: Bucket ID LF, LOOKUP: SKU LF]. I hope this helps! Kyle ... View more

Re: Formula for Range of value

byContributorinSan Francisco Forum
‎04-03-201705:23 PM
1 Kudo
‎04-03-201705:23 PM
1 Kudo
Hi Prabakaran, If you have a line item that has the Age Bucket list and the asset list as a dimension, then you can write a formula like Asset Details List.Counter[SUM: Asset Details List.Age Bucket] This will then sum the counter up by the age bucket associated with the list item. Let me know if this works. Kyle ... View more

Community Badges and Icons

byContributorin社区的反馈和更新
‎04-02-201704:29 PM
2 Kudos
‎04-02-201704:29 PM
2 Kudos
Hello! I was just wondering if there was a method users could use to get appropriate badges added to their profile and how we could get the 'Partner' symbol next to our usernames. Thank you for your help! Kyle ... View more

Re: Formula for Range of value

byContributorinSan Francisco Forum
‎04-02-201704:26 PM
1 Kudo
‎04-02-201704:26 PM
1 Kudo
Hi Prabakaran, The formula looks like it should work to me other than the names of the list items seem to be slightly different. You can go into the list and select them to ensure that the formatting is the same. Also make sure the line item is formatted as your Age Bucket list. If this still doesn't fix it, send us a screenshot of the blueprint and we should be able to figure it out. Hope this helps! Kyle ... View more

Re: List subset by formula

byContributorinAnaplan Platform
‎03-30-201709:47 AM
2 Kudos
‎03-30-201709:47 AM
2 Kudos
Hi Yoshi, You can create a line item in the module that does not have time as a dimension and use a formula to reference the total value. If you have the 'All Periods' time then you can write a select statement to reference it, or if you utilize the current period feature, then you could write the select statement using current period. This second option would require other line items to ensure that the current period has the total value. In the screenshot, I used a line to cumulate all the values and then a line to grab the yearvalue. Both of these options allow for a sustainable model where you would not have to update the formula year over year. If neither 'All Periods' or 'Current Period' are an option, then you could reference the specific full year value in the select statement using Time.'FY17' but this would have to be adjusted each year. One thing to note is that I had to pivot so line items were in columns in order to get the import into the list to work. I hope this helps! Kyle ... View more
My Accepted Solutions
View All
Kudos from
Kudos given to