Oh, sorry, @Chr1sG, that wasn’t really clear, lemme try again. 
-
I have a CRM where I track customers and their status of onboarding (using the Workflow field)
-
I made a little report that tracks total customers in the CRM and how many of them are “activated”
As we can see, my Register in X Workflow state translates to a State Rank of -2015332743211050 in the data, which is arbitrary in the worst sense of its meaning…
Here are the current State Ranks in that database:
… before they were at least round positive numbers (i.e. 1 000 000, 2 000 000, etc.).
Until yesterday (or so), the formula to count all activated customers was what my first screenshot shows:
COUNTIF([Id],[State Rank] > 3000000)
Today my colleague noticed that the number of activated customers was zero, and when I checked, I saw the the State Rank field suddenly has new values. So I had to change the formula to this:
COUNTIF([Id],[State Rank] <= -1922380244664780.2)
Pretty. 
TL;DR:
- Why is State Rank in a report an arbitrary number that can change? I understand that it is is needed to be a number for sorting, but it shouldn’t change. → I would suggest to split ID and sorting, so that the ID can be immutable and the sorting can be changed.
- Why is the State Rank not something I can see when I alt+click the single select option, where I can give it extra properties? Listing it there would make it easier to use, tho Ideally I’d want:
- Why is the State Name not be made available in reports?
- Why does the State Rank get changed without me touching the options in the workflow properly?