Something that’s been recently driving me nuts is that when you sort on a number field, the report builder shows null values first. This behavior makes no sense.
For example, in this report, I’m trying to sort on “total accounts.” When I sort by fewest, I get the following, which is expected:
However, when I reverse that sorting and therefore expect to see the highest number on down, I instead get all the null values first. This makes no sense!
I checked Excel just to make sure I wasn’t crazy. Here’s how Excel functions with null values - notice how null values aren’t considered. This is how Gainsight’s report builder should function too.
