nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Setting up SYS Modules for Time Settings

Hi,

What function would you use to display the numbered week in the Month, ex) the third week of the Month.

Tags

Modeling

Calculation Functions

Accepted answers

@neg177 You can use Previous() to get the week number for the month by referring a line item with a counter as 1 for each week.

Hope this helps

AB

@ashish.banka is correct. Another way of doing is using LAG: LAG(Week Numb Better + 1, 1, 1)

All comments

@neg177 You can use Previous() to get the week number for the month by referring a line item with a counter as 1 for each week.

Hope this helps

AB

@ashish.banka is correct. Another way of doing is using LAG: LAG(Week Numb Better + 1, 1, 1)

Quick Links

Can you help?

Unanswered questions

What are limitations on UX 'Drill down', up to what level of hierarchy drill down works?
Can we find somewhere documentation about UX drill down feature? UX is sometime showing underlying data upto 5 levels in hierarchy but doesn't work 6 or 7. Appreciate any pointers on limitations on this feature. Business wants to know up to what levels in reports they can analyze underlying data.
L3 Sprint 2, User Story 3.3 Q1 Quarter Allocation
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…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
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…