Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Rankx Function getting 1

Seeking help, for RANKX function I always getting 1 results.
I search a lot of function and I tried but it always return 1.

 

Thanks for your help

 

 

2 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    5 years ago

    There seem to be a few issues.

     

    1. Variables are immutable. Once they are set, they don't change. Move the variable code inside the rankx

    2. The ALL inside the rankx would normally be placed around the table[column], and not the table