As per the below activity information provided, do we need to write the formulas for all the line items in the module or need to write the formula for only Growth Rate % line item?
Can anyone provide clarity on this activity for me?
@SravanKumar
For all line items and not just Growth rate%.
Baseline Forecast = Data available in one of the DAT modules
Default Forecast = Use Growth Rate and Baseline Fcst to arrive at Default Forecast
Initial DF = Use ROUND function on Default Forecast
Hope that helps
Misbah
Miz Logix
Hello,
Can someone help me figure what I am missing in my formula? I've tried several formulas and I don't think is the exact formula I'm suppose to use.
I'm sharing my formula's and my DEM03 module.
Hi @Dijones128
We already determined the forecast in the DAT03 Module so you just need to pull the "Offset Volumes for 1st Forecast Year" data
Thank you for your reply, I ended up get my formulas but for some reason all of my data isn’t displaying
If we go down lowest descendants for 2 hierarchies something like this {Descendants([Planning Org].[Planning Org].[ALL].[AllMember],255,LEAVES)} then the queries timeout what is the best way to use lowest decendants so it doesnt scan the whole hierarchy
Hi! In London it was mentioned, any update on this?
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…