Hi Guys,
I am working on a module. where I should input the L1 then it should go L2 level. if I Enter the L2 then it should distribute L3. I can use the break back .
I there any functionality available for this scenario
@143kishornaidu
Anaplan is best designed for pulling the data(aggregating the data) and you will have umpteen functionalities for the same.
but when it comes to disaggregation, i think break back is the best possible option for bringing the data for higher level to lower level.
there are some functionalities like PROFILE, SPREAD, which is helpful while doing calculations like depreciation etc. which basically pushes the data.Thanks,Manjunath
You can use LOOKUP function to cascade the numbers down from L2 to L3. Note that the numbers will be flat lined across all the children of the parent
Hope that helps
Misbah
Miz Logix
With LeanIX as the core Enterprise Architecture platform for managing and rationalizing the IT application and technology portfolio, and with the out-of-the-box Technology Business Management (TBM) integration to tools such as Apptio enabling granular IT FinOps and cost management, most IT financial management capabilities…
Hi Community, It appears that values shown here for Q1 are assuming 29 days in Feb 25, when there are actually only 28. My values tie out for all Quarter values and all months shown from Apr 25 forward, and it's not possible for only a single quarter/finite range of months to differ with formula-driven values: Please…
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…