Hi,
I want to delete selected line items in a module based on their year time period.
i.e.: i want to delete all records that have a year time period format of FY19. Is there a way to do this?
Best,
Amanda
Hi Amanda, I presume when you say line items you are actually referring to list items (i.e. records)?
This can be facilitated by creating a boolean line item and creating a formula that sets the boolean to true if the year is equal FY19. Remember that best practice is to create a SYS module where you define the parameters (FY19) rather than hard coding with the formula. Once you have your boolean line configured, within the Actions tab create a a new action to Delete from List using Selection and reference the boolean line item in the "Selected using" field. Below is a helpful article on this topic.
https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Other_Actions/Delete_from_List_Using_Selection.html?_ga=2.41370218.998608532.1588597199-1008031286.1578606414
Let me know if I misinterpreted the requirements.
-Tiffany
Hey Amanda - I can't see the underlying setup that you have, but I can present a couple options that may be helpful:
Assuming you are trying to lookup on a list item to see if the data they have in a module by time is populated for FY19, you could use:
TIMESUM(DAT01.Values, SYS01.Current Period Start, SYS01.Current Period End) > 0 where this line item is a boolean formatted line item (current period start is Jan 19 and current period end is Dec 19)
Assuming you are doing a lookup on a module that has time as an attribute/property that you are flagging, you can use something along the lines of:
PARENT(PARENT(Current Period Start)) = TIME.'FY19'
Does this help?
JT
@aabalos ,
If you are wanting to remove all data from any month in FY19 from the model and you are using native Time, can you just adjust the Time Range or model calendar to remove the FY19 year. But remember, this would be for the entire model, is that what you are wanting to do?
Conversely, in rereading your post, do you have actual line items that have the name or format as FY19? Maybe a picture would be helpful to understand exactly what you are wanting to do.
Rob
Hi @aabalos I agree with @rob_marshall,
Please provide more context and a screenshot.I see different people interpreted your question differently. I actually have the same understanding as Rob. So yes; you can change the Time setting IF you want to remove FY19 from the whole model.If your ask is to remove the FY19 from this one module but leave it for other modules, then create a Time Range (from the Time Setting section) that does not include FY19, for example it starts from FY20, then use this newly created Time Range as the time dimension for the module where you want to remove the FY19 data
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…
