Search results
-
V
Order By ascending if negative, descending if positive
Hi, I am wondering if there is a way to incorporate an IIF statement into a Order By statement. I am trying to set up a query so that when X>0, field Y sorts descending but when X<0 field Y sort ascending. For context, I am trying to show the top 5 absolute values, and the top drivers of those...