Second Friday of the month formula

DMManalili
Frequent Contributor

Second Friday of the month formula

Hi, for your assistance please. How can I get every second Friday of the month? I created a line item Day identifier to get every friday but I need the second friday of the month. Thank you 🙂

 

DMManalili_0-1635845742633.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
ankit_cheeni
Super Contributor

Hi @DMManalili 

 

Rank starts to behave peculiar when used against a time dimension. See this thread  for more details.

 

What we did is use cumulate function to identify the second friday of the month. This is how the logic looks like:

ankit_cheeni_0-1635851008340.png

The idea was to identify second friday but also reset the identification when the month changes (see Dec month dates vs November).

Here is the blueprint for your perusal:

ankit_cheeni_1-1635851096398.png

 

Let me know if this is helpful 

View solution in original post

2 REPLIES 2
ankit_cheeni
Super Contributor

Hi @DMManalili 

 

Rank starts to behave peculiar when used against a time dimension. See this thread  for more details.

 

What we did is use cumulate function to identify the second friday of the month. This is how the logic looks like:

ankit_cheeni_0-1635851008340.png

The idea was to identify second friday but also reset the identification when the month changes (see Dec month dates vs November).

Here is the blueprint for your perusal:

ankit_cheeni_1-1635851096398.png

 

Let me know if this is helpful 

DMManalili
Frequent Contributor

Thank you! 🙂