How to get last day of the month

taku.s
Contributor

How to get last day of the month

Hi everyone.

 

I would like to get last date of the month when certain data is entered.

 

Image:

Image.jpg

 

I would like to get only the last day of each month that meets the conditions.

Item is List format.

Please tell me good solutions.

 

Best regards.

1 ACCEPTED SOLUTION

Accepted Solutions
Amaya
Certified Master Anaplanner

Hi, @taku.s 

 

My solution is almost the same as @Misbah  's.

I think I could adjust it to your circumstances a little.

 

Don't forget to set the summary to Time: Last non-blank.

 

the_Last_day.png

 

(By the way, your screen name sounds like Japanese.

If you are a Japanese person, please drop at Japan Community, too.

There are very few people and we want more knowledge to be shared in the Japanese language.)

 

https://community.anaplan.com/t5/Anaplan-Community-Japan/bd-p/jp

 

Best regards,

Taichi

View solution in original post

9 REPLIES 9
Ankitjain
Contributor

Can you please elaborate More on requirement.If possible please share the Module Snapshot where you are facing the issue.

Just FYI, END() can retrieve the last date of Month.Use this function with the valid condition to retrieve the date.

taku.s
Contributor

@Ankitjain 

 

Thank you for your reply.

 

Image1.jpg

Image2.jpg

Image3.jpg

I would like to know what to write in Formula of SampleB...

 

regards.

ChrisAHeathcote
Community Boss

In the target module add the items list as a dimension. 

 

Try the following function;

 

SampleA.Item [ LASTNONBLANK: SampleB.Item ] 

 

Please feedback any other solution you find.

 

Chris

 

 

Chris
HeathcoteAndHerran.com
ArunManickam
Master Anaplanner/Community Boss

Your source and target time dimension is same, then there is no summary possible by time.

 

Thanks

Arun

mujahidsalman
New Contributor

Yes, Adding END() Function will give you the end date.

Misbah
Moderator

@taku.s 

 

If you are trying to find the last date then you may want to use LASTNONBLANK function. Here is the similar post that was provided a solution

 

https://community.anaplan.com/t5/Anaplan-Platform/Last-Occurence/m-p/60894#M11038

 

Here is how I recreated  the query - I want to see what is the latest time period for transaction A or B (Here I have used Native Timescale but it can be any list formatted as well)

1. Input module with two line items

Misbah_0-1582266710980.png

2.  Create another module having formula like below

Misbah_1-1582266833377.png

Here the summary should be Last Non Blank across time series

Misbah_2-1582266894696.png

3. Create another module which will pull the values from module 2 - Since i was using native timescale I had to use Yearly Scale to check the Last non blanks in that particular year.

Misbah_3-1582266951889.png

 

Hope this helps

Misbah

 

Amaya
Certified Master Anaplanner

Hi, @taku.s 

 

My solution is almost the same as @Misbah  's.

I think I could adjust it to your circumstances a little.

 

Don't forget to set the summary to Time: Last non-blank.

 

the_Last_day.png

 

(By the way, your screen name sounds like Japanese.

If you are a Japanese person, please drop at Japan Community, too.

There are very few people and we want more knowledge to be shared in the Japanese language.)

 

https://community.anaplan.com/t5/Anaplan-Community-Japan/bd-p/jp

 

Best regards,

Taichi

taku.s
Contributor

Hi,@Amaya - san

 

Thank you for your reply.

I corrected it with your advice. I got the result I wanted.

Thank you so much.

 

Yes, I'm Japanese. And I'm a beginner...

I will refer to Anaplan's Japan community later.

 

Arigato-gozaimasu!!

 

Best regards.

 

Taku

Amaya
Certified Master Anaplanner

待ってます!
We all welcome you!