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
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
