Get Lastoccurrence data

Highlighted
Occasional Contributor

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. 

 

tompatrickting_1-1596554374184.png

 

 

Thanks in advance for the help.

Tom

 

4 REPLIES 4
Highlighted
Certified Master Anaplanner

Re: Get Lastoccurrence data

Hi @tompatrickting ,

 

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

 

~Jitendra

Highlighted
Master Anaplanner/Community Boss

Re: Get Lastoccurrence data

@tompatrickting 

 

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

Highlighted
Master Anaplanner/Community Boss

Re: Get Lastoccurrence data

@tompatrickting 

 

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

Misbah_0-1596557038027.png

Misbah_1-1596557115975.png

 

Highlighted
Occasional Contributor

Re: Get Lastoccurrence data

Thanks @Misbah, this works perfectly.