Rankcumulate - unexpected result

Hi,

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

Answers

  • @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.

     

    Misbah

    Miz Logix