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

API certificats renewal
Hello Anaplan Community, We are currently facing an issue related to certificate validation and would appreciate your help or guidance. We are getting the following error: Unable to build certificate chain for Cert [subject DN = EMAILADDRESS=********, CN=service account email address, cert serial number = XXXXX; issuer DN…
Time hierarchy filter new ux when brought forward option is turned on?
Hello, Does anyone know any workaround or a solution to be able to enable the hierarchy filter in new ux when the brought forward option is selected in backend? I do not see the above hierarchy filter option if I enable the brought forward for a line item-
Docusign Integration
Hi I'm looking to speak to people who have used/are using the Docusign integration in their business. We are exploring the possibility, but we find the current setup quite limiting in terms of how an end user would interact with the integration, but also issues with concurrency and number field formats. Would appreciate…