Question on RANKCUMULATE formula

ChrisHeathcote
Community Boss

Re: Question on RANKCUMULATE formula

@ClarenceA 

Is this view filtered in any way?

 

The view has been sorted so the view is different to the actual order of the list items in General Lists.

 

That is why they are not in numerical order.

 

Undo the sort.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
ClarenceA
Regular Contributor

Re: Question on RANKCUMULATE formula

Hi @ChrisHeathcote @PhilippErkinger @vinayvm 

With reference to the RANKCUMULATE formula in Account Counter 2, my bad. Think I found out why its coming up this way e.g. 1 to 5, 41 to 45 etc. is because the way its coded in the A1 Account list so the formula is probably working correctly, not as expected but correct. The sequence follows the code in the list rather than row order.

Kind regards,

Clarence

TAR02 Account Review 210507_2.jpg

ChrisHeathcote
Community Boss

Re: Question on RANKCUMULATE formula

@ClarenceA 

That is correct.

Therefore, if you change the row order in the grid the sequence will not update accordingly. 

I can see that you have applied a sort. If you were to remove this and revert the list back to it original order then the sequence will increase as per your expectations. 

You can run an action that will re-sort the list as per a logic determined in a systems module.

Sort list action

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

ClarenceA
Regular Contributor

Re: Question on RANKCUMULATE formula

Hi @ChrisHeathcote yes you're right if I uncheck the sort I can see the numbers in the correct sequence! I'll check off your reply as the solution to the question.

Kind regards,

Clarence