HI
I want to get prevous year week values . Without hardcoiding means
week-52
How can i achevie that
Previous year is week format & when ever the 53 week comes that data come that show not go current year 1 st week
Hi, I am not 100% sure what is the end goal of this, but it sounds like you could try using OFFSET and maybe RANK to try finding solution to this.
i want to get previous year weeks to the current year . but Whenever the the 53rd week comes thats should be stand alone . which means the 2022 53 rd shouldld not comes to 1st week of 2024 . But Offset will not work bcz of timeperiod format and don;t know about the rank
@kishoreanimi
Have you tried the AddYear() function? That returns a date and then you can wrap that function within the Period() function.
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
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…
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.…
