-
Timesum check
I want to do a timesum for a value from first month of current year to last month of current but it is not returning value. I have used logic as TIMESUM(Amount,First month of CY, Last month of CY,SUM) Where amount is value, first month of CY is Jan 25 and last month of CY is Dec25. Amount line item has time on whereas for…
-
Model Calendar vs Time Ranges
Hi, My model calendar is currently using FY time with start period being Jul-June. For another module I need a time range that uses Calendar Year, Jan-Dec. I am not sure if it's possible. I tried the Time range function, but it defaults to Jul as a start period. Is there a way to accomplish this?
-
Architectural Use Cases for setting Action Imports / Import Data Sources to Production Data
There's only 1 practical architectural use case I can think of at the moment why you would consider setting actions as production data but would like to check in with others if there are other use cases I have not considered. The one use case I have considered is if you are splitting the same model in to regional models,…
-
Line Items not Showing for 'Create Shipping Export' in the Level 2 Conclusion
Hi - I know this is a frequently asked question but I believe there's something missing in all of this that I can't spot. I've been dwelling on this for days and this is due tomorrow. Can anyone help spot the issue(s) I'm encountering? All Modules: INV01 Table View: INV01 Blueprint View: INV05 Line Formula: TRA01 Grid…
-
Need help in formula to select specific month/year(cutoff date) to calculate larger calculation
share some exmample
-
Pulling a column into an Import Module
I need to pull data from one module into another. Here's a breakdown of my setup: Module1(G4 Metro Module): This module is dimensioned by G4 Metro list and includes a line item that maps 'Node classifications' to the G4 Metro items. Module 2 (Import Module): This module is dimensioned by a numbered list (UID) and has a…
-
Version as general list
In my model the version are built using general list. In this instance if for restatement i want to copy over the complete data from one version to a new version how can i do that?
-
Not able to track the historical changes for a formula cell
Hi People As per above SS for Lineitem 'C' I cannot see the history for this cell , whenever there is a change in values of input lineitems 'A' or 'B'. Also, even If I change the formula for 'C', then also cell history for the cell does not showup. Whereas when I check the 'History' from Settings panel then it just shows…
-
Anaplan Data Import Issue: Numbered List Code Mismatch
Hey Team, I'm facing a bit of a challenge trying to pull data from a source module into a target module. Here's the situation: The source module has a numbered list dimension, and I need to bring one specific module's data over. I've already determined that the target module also needs to use a numbered list because there…
-
In Level 2 - Supply chain model - do my time settings look right?
The only reason I ask is because I've been unable to achieve some of the UX pages and, asking in prior questions, I seem to have everything right but the UX pages still aren't working. Would someone mind taking a look at my time settings? Thanks in Advance!
-
Is there a way to filter the dropdown in a Report page similar to the Board page?
Hello, Is there a way to filter the dropdown in a Report page similar to the Board page? I don't have the same capacity when in the Report page. There's no Gear icon to filter: Below is the screenshot from the Board page where I was able to filter my toggle dropdown:
-
Is there a way to remove the extra empty columns in Report App?
Hello, I'm building report pages. Is there a way to auto-fit the data such that empty columns won't show? It would look so much better:
-
Identifying orphans in a composite hierarchy for deletion
Hi, I have an L2 list that is used to capture staging data. The parent to this list is L1. The user runs a import action via the UX and a csv file to load serial numbers into the L2 list (L2 is a numbered list) The user has been provided a template to upload the L2 list wherein they need to enter the parent and that is…
-
How to calculate number of months between two dates when one date falls outside of model time range
I am needing to calculate the number of months between two dates, one of the dates falls outside of the model time range. I am needing this so I can do a straight line depreciation cacluation but the # of months formula returns a blank value because of the date/time range isue.
-
ALMing multiple revision tags into Production environment
Hi, I have a scenario wherein I have multiple revision tags ALMed from Dev environment to the UAT environment. They have been synced in the correct order. I now need to sync to Production with UAT environment. I understand that revision tags are cumulative in nature but wanted to understand any possible implications of…
-
Activity: Prepare Data Exports
Hello, i had a trouble to understanding to fill the formula on "Code" line item, if the purpose was to get the code on G3 Location, why don't just make the line item format List and refrence G3? well i try that, and i got another question, why you cannot refrence straight to G3 grid Code? and what the downstream mean in…
-
Export Function
Hi Anaplanners, Hope you all are doing good! I have one question regarding export. Lets say we have module dimensioned with 4 dimension . And we cannot add 4 dimension in row. I have added time dimension(Year) in Page selector. While exporting I dont want time to be displayed in export file. Is there and possibility in…
-
Restore to ID in production model (Deployed)
Hi We have a development model (standard mode) and a Production model (Deployed mode) with ALM between them. The latest revision tag was pulled in Production more than few weeks ago. A production user updated data in production model last week. They haven't made any significant change since then but want to revert that…
-
Exporting and distributing management reports
Hi, We have created some really great looking customer reports in Anaplan but it is very time consuming exporting each individual customer report and then renaming the file to the customer name. We have over a hundred customers to issue reports to. Has anyone in the community come up with a way to expediate this process? I…
-
Still stuck on "Confirmed PO Delivery" and "Confirmed PO Receipt", something isn't adding up.
I'm honestly not sure what to say about this one because I thought I had nailed down all the formulas, and then the corrected formulas, but here we are. I think I can narrow down where the errors are taking place, I just don't know how to correct them. In all truth, I could really use a review of all the formulas in…