line item: First week of timescale?

how do I build the formula in 'Sys01 time settings by week' for this line item

Accepted answers

All comments

how do I build the formula in 'Sys01 time settings by week' for this line item i was looking at currentperiodstart and comparing it with start... cant quite figure out the relationship

rob_marshall

@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.

aseem_mutneja

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.

Donna Marie

The learning materials hinted offset function

should i use offset(1,-1,0) = 0

Donna Marie

what if first week of timescale is set as a Boolean?

rob_marshall

@Donna Marie

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

aseem_mutneja

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:

	Week 1	Week 2	Week 3	Week 4	________________	All Periods
ItemWeek	Week 1	Week 2	Week 3	Week 4	________________	Week 1

First Week of Time Scale? : ItemWeek=ItemWeek[Select: Time.All Periods]

This would only be true for Week 1.

Hope, this answers.

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
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.…