Best Of
Re: Level 2 Sprint 2/3 SYS08 issues with Parent Family
- Please check the List Product, if they are not orphaned (loaded properly to correct parents)
2. If the above solution did not worked, is it possible to also share the Property and the Details of the General List Product Family? In case you have issues on the display Name.
ramonito
Re: Dynamic Cells Calculation (DCC)
I came up with a similar idea about 1.5 y ago but did not get much traction:
https://community.anaplan.com/t5/Idea-Exchange/Formula-Access-Driver/idi-p/46670
Would be a great addition to the roadmap!
Axel_H
Re: Break data equally into Weeks from Months in 445 Distribution
Hi,
Not knowing much about your build, I would recommend something like:
- At the week level, create a numeric line item that contains a formula with a 1 in it. The only dimension here is your weeks (to keep the model small).
- Aggregate the 1's to the Monthly input level to get the number of weeks. The only dimension here is (presumably) Time in Months.
- Go back to the weekly level and divide the monthly amounts by the number of weeks
Cheers!
Groups Mission and Vision
Mission: provide the place and tool to facilitate connection between people with similar interests, business goals, or objectives.
Vision: facilitation through non-Anaplan employees allowing customers to train customers and increasing their expertise within the Anaplan ecosystem.
Anaplan Groups are for people with similar interests, business goals, or objectives to interact and collaborate along their Connected Planning journeys. Through a wide variety of events and dedicated Community spaces, Group members can discuss and exchange best practices, collaborate on challenges, and expand their professional networks through long-lasting relationships with like-minded peers.
Anaplan Groups equip members to do more and go further with Anaplan. Meaningful peer-to-peer connections, a robust online experience, and diverse engagement opportunities provide the mutual support, education, and shared knowledge necessary to accelerate and sustain their Connected Planning journeys.
Anaplan Groups provide a unique opportunity for members to:
- Discover and share return of experience from other local customers
- Create our own network of fellow Anaplan users and experts
- Enhance your Anaplan knowledge and skills with the technical groups
- Deep dive on existing and upcoming product updates
- Share your challenge and find solutions with the groups
- Recognize local Anaplan Champions
Why join an Anaplan Group?
- Enhance your Anaplan knowledge and skills
- Meet and network with fellow Anaplan Community members
- Have fun and be involved!
Sprint 2: DEM02 Module Formula
Hey,
When creating the DEM02 Volume Growth Rates by Week module, the activity wants you to "Write a formula to pull Volume Growth Rates value (in months) from DEM01 module and convert to weekly value". However, under the Anapedia resource it links to explicitly states that the functions listed can aggregate from Weeks to Months but cannot segregate from Months to Weeks. Which is a problem, as it is what we need to do for this activity.
Has anyone figured out how to do this?
Joh04924
Re: (NMX) L2 Model Building - Sprint 3
Based on the formula you provided, it seems that you are trying to calculate the "Confirmed Purchase Order Receipt" for the INV01 Module. However, there appears to be an issue with the formula logic.
The formula uses an IF statement to check if the "Confirmed PO Delivery" is greater than zero. If that condition is met, it uses the OFFSET function to retrieve the "Final Shipment Amount" value with an offset of "-Final Shipping Time Weeks" rows above the current cell. Otherwise, it returns 0.
The problem may lie in the usage of the OFFSET function. It is essential Clarks Customer Survey to ensure that the referenced cells and ranges are correct. Check if "Final Shipment Amount" and "Final Shipping Time Weeks" are accurately defined ranges or cell references in the worksheet.
Furthermore, verify if the units of "Final Shipping Time Weeks" align with the requirements of the OFFSET function, as it requires a numeric value for the row offset.
To troubleshoot the formula, cross-check the cell references, make sure the data types are compatible, and validate the logic against the intended calculation. By thoroughly reviewing and testing the formula, you should be able to identify and rectify the issue, helping you to achieve your certification goal. Good luck!
Re: (NMX) L2 Model Building - Sprint 3
I think you should be applying IF Confirmed PO Delivery <> 0 THEN……….
<> is not equal to sign,
Hope it helps 😊
Re: 'Used in Dashboards' and 'Used in Action/Import' for SAVED VIEWS
Can we also add 'Used in Export Action' as well? Biggest pet peeve right now when doing integrations out of Anaplan is not knowing which saved view is associated to the export action!
wquan
Re: Dynamic Cells Calculation (DCC)
I think it would be really challenging for the Anaplan calculation engine to evaluate every cell if it is a "Manual Input" or "Calculation", but an extension to the "Formula Scope" to cross with other Lists than Versions in order to create some slice&dice of a module be considered as "Input" or as "Calculation" for the same Line-item it would be really useful.
Looking forward to it!
Alex
Re: Period Function is not giving the desire output.
Hi Araj,
Indeed the period function will only retrieve and show periods that you have in your model calendar (time settings).
Though, this works with time ranges as well. So if you need to display a specific time range as a result of a period or have a function that should calculate beyond the model calendar setting, you can manage that by using a time range.
Hope this helps, Andris.
