How to suppress zero or missing values when using the rank function.
Example:
if(rank(sum(Value),0,1)<10,1,null())
if(rank(sum(Value),0,1)<10,1,0)
Environment:
Resolution:
The correct way to accomplish this is to use aggr() function in the expression.
Please refer to following example:
if(aggr(rank(Sum(Value),1,0),Dim)<10,1,0)