Rankcumulate - unexpected result


I am using the rankcumulate function but I am getting some really unusual results, wondering if anyone could assist as I have no idea why this is occurring?  I have attached the formulas and also the results. 

Thanks in advance


  • @kristenr 

    Screenshot doesn't show "Total Revised Sort Order"Line, neither in Blueprint view nor in Module View. Need to see that line to help you better.



    Miz Logix