how do I build the formula in 'Sys01 time settings by week' for this line item
@Donna Marie
if this doesn't answer your question, it might be helpful to attach a couple of pictures. But, to return the first period of the timescale, you can use the LAG function formatted as a bolean.
You need to get the current week against week dimension in a line item and keep the summary as "First Non-Blank" - It will set the value at all time periods=First Week of Time scale. Here are the two line items:
The formula for boolean is: ITEM(Time) = First Week of Timescale[SELECT: TIME.All Periods]
Hope, this is what you are looking for.
The learning materials hinted offset function
should i use offset(1,-1,0) = 0
what if first week of timescale is set as a Boolean?
No, with LAG and if you want to go back, you use a positive 1 as what I showed above. If you use negative 1, it will go into the future (like a LEAD).
Rob
Yes - that would the result. Line item names in the screenshot, I shared are somewhat misleading.
Line Item 1 - We can name it ItemWeek - dimensioned to Time - week
ItemWeek= Item(Time) - Summary would be first non-blank
Results of this would be:
First Week of Time Scale? : ItemWeek=ItemWeek[Select: Time.All Periods]
This would only be true for Week 1.
Hope, this answers.
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue For versions 1.6, 1.7 and 1.8 of the PowerPoint Add-in elevated privileges are required to install the add-in through command line and for the "all users" option. Workaround * Installing through…
