Get Lastoccurrence data

Hi,

Please help how can I get the last value in my module. I tried to use a rank function but can't reverse the ranking to ascending because the source value are the same amount.

Thanks in advance for the help.

Tom

Accepted answers

Misbah

@tompatrick.ting

If you don't want to tweak the formula in your current line item create another line item. See if below helps

All comments

Jitendra.Vishnolia

Hi @tompatrick.ting ,

Please check this thread https://community.anaplan.com/t5/Anaplan-Platform/Last-Occurence/m-p/60894#M11038 It will help you out.

~Jitendra

rob_marshall

@tompatrick.ting

Is your Floor Type a list member? If it is, you can create another module to get the max of the Rank line item and then in the above module for the boolean, compare the two.

Rob

Misbah

@tompatrick.ting

If you don't want to tweak the formula in your current line item create another line item. See if below helps

tompatrick.ting

Thanks @Misbah, this works perfectly.

Quick Links

Can you help?

Unanswered questions

12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…