RANK function ONLY returns 1 when ranking in Anaplan Time dimension. Bug or intentional?
I am new to Anaplan, this is my first post ...
Set up to Demo problem:
- 2 dimensdional module
- Anaplan Time dimension in columms;
- 2 line items in rows;
- 1. Some numbers to be ranked
- 2. RANK function ranking Line Item 1
RANK only returns rank 1 for all the numbers ranks, even though they are different in size.
Is this a bug, or is there some reason why rank doesn't work across a time dimension?
This is NOT a question about ranking Time Periods, that works fine. It is about ranking when the dimension is Time. It would appear to be a bug, as I can't see any reason why it shouldn't work.
It would not be a solution for me to do the same but with a List of dates covered by the time period. That works fine, but I have other solutions to my problem that I would use. It is just that it would be immensely convenient if RANK worked across the Time dimension.