-
LOOKUP function Blank result
Hello everyone, I am currently working on a model where i am using some data i imported in formulas to create some relevant data for a YTD model. I am trying to implement the following excel formula : IFERROR(VLOOKUP(A2;'TCD CRISTALLINE'!H:I;2;0);""). So in the first part of the implementation i started off by trying to…
-
Trying to map data to a line item from a list
Hi, I'm creating an upload into a list. I've then created a module that looks back and returns the values from the list. I need to be able to map certain factories to certain line items. So if my factory is 1 then i need the line item to be returns from another module with a certain heading. The reason I can't use a…
-
spread of value on identical children
Hi, I have two modules, using two different list List1 and List2. List 1 module has a member FM and a line item amount value as 100. List 2 module has members FM1, FM2, FM3 & FM4. I want to spread FM value 100 from module 1 in module 2 having total four member starting with FM as 100(value)/4(count of FMnodes) = 25 each.…
-
New Item addition for List(not numbered list)
Hi, Can I add create new item button for a List(not a numbered list). Regards Madhu
-
group by line item
Hi, I have two different modules using two different dimensions. module 1 module 2 In module 2 I have an amount value, which I want to pull in to module 1. similarity between two module is Line item A (repeating text value), while pulling in to module 1 ,I want to group in amount value by Line item A( common line item in…
-
Dimensions type
Can we use one of the List properties as a Dimension to create a Module in Anaplan?
-
Formula Error Log
As a model builder and workspace admin, formula errors can be costly. My idea is to add an error log that tracks formula and calculation errors. This will help document who was doing what when something goes wrong. It will also help with enablement as you can review the error log and use it for training - ensuring that the…
-
Fiscal Year End
Hi, I want to get the value for my fiscal year end into a module (Date format) *See picture E.g. For my line item "Currentperiod" I can enter CURRENTPERIODSTART() in the formula field and get 2019-04-01 I want to do the same for when my fiscal year ends e.g. 2018-10-31 (should be dynamic)
-
Retrieve dimension as line item
Hi, I need to retrieve the selected dimension as a line item. For example, imagine I have a list with three items, Scenario 1, Scenario 2 and Scenario 3. What I need is some kind of function so that I can return the selected dimension, for example Scenario 1 in a line item. Any help is appreciated, thanks a lot!
-
Auto Number
Hi, I have a list of numbers, they are used for unique product codes. As you can see the last number we used was 201028. When a user enters a product in another module, it looks up the BVFSKUID from this list using the BVFSKU column, If there is no matching record, we need to create a new line in this list, with the BVFSKU…
-
Lookup on Line item subset "Parent"
Hi, I have a collect() module dimensioned by a line item subset and time and another by account and time, the account module is referencing the collect module using a lookup based on a mapping. The mapping dropdown allows me to select any member in the LISS and the formula works if I pick the first member i.e. Rent,…
-
Formula to pull dates from History log - Cell Updates
Hi! I would like to be able to pull information about the date/time when a cell is update. Example: If I tick a Boolean field called Final Position to mark a deal as ready to be contracted, I'd like to have an associated Final Position Date automatically fill in with the date that this cell for the deal was ticked
-
List Property in Text and referring the text from Module as List formatted
May I know how I am supposed to retrieve List Property in Text as List formatted line item given the list property in text matches a list member. Thanks in advance. Greg
-
SUM COLLECT
Hi Anaplanner, i have problem with take amount from GL Mapping (picture 1) to stagging (picture 2), and i want sum by CC(number), how must i do ? in the picture 1 i use collect to take amount in GL mapping
-
Filtered list doesn't show all level of hierarchy
Hi I've created a filter using a list. Set it up as a boolean to only show products that I want to see. Issue is when I apply the filter i see the correct list - not the parents. I can't select the parents only the children. Any idea on what I'm missing.
-
Circular Reference - calculating average
Hi all, I hope someone can help me, because I'm currently struggeling with a particular use case. I'm creating an extrapolation for a client, and they want to use a combination of 3 extrapolation methods: Month on Month (MoM), Year on Year (YoY) and a Manual Run Rate (Manual). Each of these methods are given a weight,…
-
Numbered Lists
Hi, I have a numbered list, in which i want the numbers to start from 1. I have used this list as dimension also have referred in some formulas. i entered wrong numbers when i was inserting numbers to the list. Now when i enter the numbers it starts from the next index number. is there any way i cant reset it? Thank You
-
conditional formatting based on text value
Hi All, I have a text formatted line item which gives me the text message "Error" or "No error" based on condition satisfied. I want to color all the row having message "Error" as light yellow and "No Error" as light green. Regards Madhu
-
Time Summary
Hi, I need to have a SUM summary for a line item but it doesn't add up but results to zero instead. I attached a screenshot for reference. Thank you.
-
New member or parent change flag
Hi, I have Account List, when my target list is updated with new member can it be highlighted in Dashboard. And Also when change in parent of the member can it be highlight. Please let me know Thanks Asha
-
Avoiding circular references with calculations on Previous List Item (Numbered List)
Hello community members! I am facing an issue which i cannot seem to find a solution to, but that someone might be able to help! This particular exercise started as a way to deal with massive amounts of sparsity in a model used by my employer. The business has a dimension (monthly vintages) representing monthly loan…
-
Return Summary Value/Parent Value
Hi Team, I'm trying to create a function whereby I can return the parent value of a list item without using SELECT. I am trying to use LOOKUP & it is not working I have a source module with a list (Machines - with a top level of Total Machines), a Mapping module with the Machines list and a line item returning the PARENT…
-
Flagging Non zero , number formatted line item
Hi All, I have a number formatted line item, i want to flag this field in another text formatted line item. saying its " error in value" else " No error", based on blank or non blank of first line item. Regards Madhu
-
How to bring in previous balance into current module? Or how do I bring in a rolling balance forward
I am creating a balance sheet. I am hoping if anyone can show me the best approach. I have two module. Previous balance module and current Balance sheet module. My previous balance module have no time scale. I want the previous Ending balance in my current module. I attached 2 screen shot to show you what I mean. When I…
-
Is it possible to have 2 different formula on the same line item?
I am creating a module that needs 2 different formula on a bunch of line item. Basically, if it's Actual, than its formula 1, if it's Forecast than it's formula 2. Is that possible, or am I better of creating 2 different module and using dashboard to create this? I know i can confine the formula to Actual or Forecast in…
-
Subtracting Months when using lookup
Hello.. I'm trying to figure out how to write a lookup formula that will subtract months. For example, I have the following line items Hire Date (Month format) Set for Jun 19 Revenue (Number format) Has 100 for Jan and each month increases by 100 (so 200 for Feb, 300 for Mar, etc) Test Result (Number Format) In Test…
-
Increase in more than 1 million times for Breakback line items
Proposal : Increase in more than 1 million times for Break-back line items Benefits : perform large inputs in break-back for initially very small, but non-zero values, excluding the step of force zeroing values by each cell before break-back.
-
To display a Text message in the dash board based on the Variance
Hi, To display a Text message in the dash board (Separate Grid not part of the line item) based on the Variance (If it is 0 to display message like " No Difference", If it is 1 " Need to take corrective action" ) Kindly Suggest on the same. Thanks Usha
-
Returning Parent/Summary value
Hi team, I'm attempting to create a function whereby it will return the line item value of it's parent without using SELECT. I have a target module with Machines List (Top level All Machines), a source module with Machines list and a system module with the Machines list & a line item returning the Parent of that list item…
-
If date falls within a date range in a list, then apply the end date of the date from the list
Hi, I have the following: • Module with a column for Lease Ending Date - My particular date I'm using for this example is 7/14/19 • List built that houses bi-weekly ending dates the Lease Ending Date can fall into (Goes from 2/3/19 to 2/17/19 to 3/3/19, etc.) - The date range the Lease Ending Date falls into is 7/8/19 -…