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

How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
How to use Client ID and Client Secret for API request directly?
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…