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
@tompatrick.ting
If you don't want to tweak the formula in your current line item create another line item. See if below helps
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
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
Thanks @Misbah, this works perfectly.
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
Estimated Level of Effort: <4 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L1 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased response time to address risks Increased forecast accuracy You Might Also Like: * Tops-Down Allocations Historical Snapshotting One of…
