Hi everyone.
I would like to get last date of the month when certain data is entered.
Image:
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.
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.
(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
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.
@Ankitjain
Thank you for your reply.
I would like to know what to write in Formula of SampleB...
regards.
@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
2. Create another module having formula like below
Here the summary should be Last Non Blank across time series
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.
Hope this helps
Misbah
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
Your source and target time dimension is same, then there is no summary possible by time.
Thanks
Arun
Hi,@Amaya - san
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!!
Taku
Yes, Adding END() Function will give you the end date.
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…
