Forum Discussion
Rank Skip Not Working
Hi Anonymous ,
It can only accept one condition, but you can have the conditions you need worked out before that happens. For example, [Value]=A*0.2+B*0.3+C*0.1+D*0.4. This also sorts the four conditions in a way.
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Can RankX accept multiple ranking criteria? The Skip in RankX works but I need all 4 criteria to be taken into account for each value or else it just spits out the "Original Rank" column.
The code works perfectly except it won't do skip for ties, even with Skip specified.
Hi Anonymous ,
It can only accept one condition, but you can have the conditions you need worked out before that happens. For example, [Value]=A*0.2+B*0.3+C*0.1+D*0.4. This also sorts the four conditions in a way.
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.