Hello,
I have ranked the first 6 records according to various requirements (see two double 1's and 3's) and I'd like to keep these rankings, but now I've joined some additional records (see last two) where I need to identify their ranking to be 7 then 8. I've tried using a Multi-Row Formula but I continue to get an error that field "" is missing: If IsNull ([Rank]) then [Row-1: Rank] +1 else [Rank] endif
I'm new to the Multi-Row formula so could be I'm not using it properly, but essentially I want the formula to look at the record above and then add 1...should be simple?
Does anyone have a solution on how I can easily add these two rankings?
Rank | ID | Product |
1 | 6 | Chicago News |
1 | 1564 | Chicago News TMC |
2 | 24 | Dallas Morning News |
3 | 749 | LA Times |
3 | 60919 | LA Times TMC |
4 | 645 | Seattle Times |
5 | 1998 | Wilmington Sun |
6 | 11183 | Huntsville Times |
[Null] | 70854 | Georgia Pacific |
[Null] | 6492 | Wisconsin State Journal |
@sheathington One way of doing this