Get Lastoccurrence data

tompatrick.ting

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

 

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

 

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

tompatrick.ting

Thanks @Misbah, this works perfectly.