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 ma…
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 t…
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
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 ma…
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 pa…
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 meth…
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…
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…
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 …
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 …
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 (Ma…
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 ite…
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…
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 …
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) H…
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 zero…
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 correcti…
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 sourc…
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 …
Hi all, I have a module with data value against every month, and my process takes care of loading the new file data to the module. before loading new data file, I want to have a action to cleanup the …
Hi, Please let me know if anyone can help me on the below question. I was trying to analyze an existing module. Here is an simple example of the logic I was trying to analyze. I have 2 modules namely …
I am creating an income statement module. Inside the module I want to create a few line item that is sandwich within a list. List - COA, Department, Line Item - Amount Example. 5000 (A part of my COA …
Hi Anaplan, When you have multiple conditional formatting rules or you create a new conditional formatting rule you currently cannot re-order the conditional formatting rules. This can make it difficu…
Hello Anaplanners - I am trying to add a 2nd column on this module that calculates variance between 2H Budget minus Forecast as you can see in the 2nd pic. 1st pic shows my versions. Every time I atte…
Hi I want to return the sum of values for a line item for my forecasted months. The module I want the value to be returned in has no time dimensions. Originally was using a look up to look at a certai…
Hi Team, I have a module in which the Timescale is Days. Now I need to get the Day from the date. E.g. for a time period 26 Jul 2015, I want to get 26 as my day. Could you please guide me on how to do…
Hello, Can't see how this was done in the allocations video. I have a list for products, and a line item for sales. I want to introduce a line item that returns the total sales for all products agains…
Hi, Has anyone experimented with having Sub Districts in their Territory and Quota Planning? For FY20 we have a new requirement to merge our North East District 2 and North East District 6 into one di…
