Help with Rank

I've got some SQL that is returning a Rank - sort of. It ranks the data and then repeats when the larger group changes.

Example:

...

I'm not sure why my SQL is doing that. It's not my SQL for one thing and it's fairly complex. How can I use - maybe - a Multi-Row Formula Tool (or some other tool) to look at the row before and if the same number then add 1?

Thanks in advance for any help.

Workflow

Preparation

Accepted answers

rarmstrong

Using the Multi-Row Formula tool, select "update existing field" and use this formula:

IF [Field1] = [Row-1:Field1]
THEN [Field1] + 1
ELSE [Field1]
ENDIF

Replace [Field1] with the name of your field

Brad1

Never mind. I got it.

All comments

rarmstrong

Using the Multi-Row Formula tool, select "update existing field" and use this formula:

IF [Field1] = [Row-1:Field1]
THEN [Field1] + 1
ELSE [Field1]
ENDIF

Replace [Field1] with the name of your field

Brad1

Never mind. I got it.

Brad1

I like yours better. Thx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703