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

Dividing (not formating) all the results by 1000
Hello, Is there a quick way, in Anaplan XL to divide all the results by 1000 without creating a measure for every row or every column?
ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
RTO and RPO details required
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.