Get Lastoccurrence data

tompatrickting
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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

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

 

View solution in original post

4 REPLIES 4
Jitendra.Vishnolia
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

rob_marshall
Moderator

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

Misbah
Moderator

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

 

View solution in original post

tompatrickting
Contributor

Re: Get Lastoccurrence data

Thanks @Misbah, this works perfectly.