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.