Forum Discussion

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

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