Addresses the latter part of this issue. Specifically, it addresses:
There is another issue where both blank cells and cells with NA are considered "zero" and so the blank cells do not sort with other blank cells, NA cells do not sort with other NA cells
The desired behavior was articulated as follows:
Descending order goes large -> small -> blank -> NA
Ascending order goes NA -> blank -> small -> large
I tested the changes to totalToSortKey, approvedToSortKey, and percentToSortKey in ClinEpi and Plasmo dev sites, and both sites appear to behave as desired.
Addresses the latter part of this issue. Specifically, it addresses:
The desired behavior was articulated as follows:
large -> small -> blank -> NANA -> blank -> small -> largeI tested the changes to
totalToSortKey,approvedToSortKey, andpercentToSortKeyin ClinEpi and Plasmo dev sites, and both sites appear to behave as desired.The first part of the linked issue is handled in this PR in
WDKClient.