Rank Formula Issue - Not Starting at 1

Hello,

I am running into a strange issue with the rank formula. In the attached screenshot, you can see a line item with the formula:

RANK(1, ASCENDING, SEQUENTIAL, CURRENT FLAG <> Previous Current Flag, Current Flag Mismatch)

I have displayed all related line items. A screenshot of the filter on the view has been provided as well.

The line item "Current Flag Mismatch" has the formula:

CURRENT FLAG <> Previous Current Flag

This view is also filtered (screenshot of that attached as well) and sorted ascending for the RANK line item. I am struggling to figure out why the rank starts at 10,293 instead of at 1! This doesn't really seem to make sense. Any help would be appreciated.

Thanks,

Robin

Rank_issue_-_formula_+_view_91772.PNG

rank_issue_-_filters_91772.PNG

Accepted answers

RobinSilk

Already tried this, didn't work. I did find the issue though:

unparented items in the list (orphans)

Although you cannot see them in the module, they were being counted by the formula. Deleting out these items would presumably fix the issue.

All comments

Misbah

@RobinSilk

RANK(1, ASCENDING, SEQUENTIAL, CURRENT FLAG <> Previous Current Flag, Current Flag Mismatch)

Remove the last parameter in the above syntax - one it is not needed, second it is repetitive.

Try this

RANK(1, ASCENDING, SEQUENTIAL, CURRENT FLAG <> Previous Current Flag)

Misbah

RobinSilk

Already tried this, didn't work. I did find the issue though:

unparented items in the list (orphans)

Although you cannot see them in the module, they were being counted by the formula. Deleting out these items would presumably fix the issue.

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…