USING RANK IN NEXEL

Previous Member
Previous Member
500 Up Votes 500 Likes 500 Comments Second Anniversary
in Platform

How to use Rank Function in NEXEL, IS it possible to use,What is the syntax.

Answers

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

    Hi Expert,

     

         Please do reply on this

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi Prakash Singh,

     

    you might want to have a look at this document: Nexel Complete Formulae library which should answer any questions. On Page 425 you'll find "RANK".

     

    Kind Regards,

    Helmut

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

    Hi Helmut Heimann , I am using the function but not getting any result,Syntax that I am using is =Rank(@b,*,LastRow), But its not showing any result.Please do the path find for the same.

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

    My Original Syntax is =RANK[@a;Range(*;*:Last Cell;*)]

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    edited March 2020

    Hi Prakash Singh,

     

    your syntax should read as follows: "=rank( [@a;*;*], [@a;*;*;Range.whole] )", have a look at this example:

     

    image

    Don't forget to build this as a "single entity rule".

     

    Kind Regards,

    Helmut

  • Previous Member
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

    Thanks a ton , please keep in touch.

Categories