Sorting date and override

Occasional Contributor

Sorting date and override

Hi there,

I need to sort by both the plan effective date (in reverse chronological order) and if an override was filled out.  However when I click on the sorting I can only sort on the date line item or the override line item.  When I sort on the date line item it ignores the overrides that do not have a date and when I sort on the overrides, the dates are not sorted.  Can I not sort on both line items?  If I can't sort on both items what is a way to get pass this? 

Thanks!

1 REPLY 1
Highlighted
Master Anaplanner/Community Boss

Re: Sorting date and override

Hi Jmanaplanner46,

 

Have you tried using the RANK formula and then sorting by the rank

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/RANK.html

Create a new line item called 'Rank sort' and then rank the overrides as you need to and then use the dates as a rank group argument. Then just sort the module by the rank line item

Let me know if this works

 

Regards,

Anirudh