USING RANK IN NEXEL

Previous Member

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

Previous Member

Hi Expert,

 

     Please do reply on this

Helmut Heimann

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

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

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

Helmut Heimann

Hi Prakash Singh,

 

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

 

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

 

Kind Regards,

Helmut

Previous Member

Thanks a ton , please keep in touch.