4 Replies Latest reply on Oct 30, 2015 10:01 AM by Simon Runc

    Show Ranking as NULL if Wildcard filter is used

    Jackie Klein

      Hello,

      I have a worksheet that uses the RANK function and the Rank value is displayed on the worksheet. I want the Rank value to be NULL or blank if the Wildcard Search filter is used, as otherwise the ranking isn't correct when the Search filter is used.  I tried the following, but the Rank shows as NULL all the time - regardless of whether the Search filter is blank or not, so doesn't appear to be working correctly:

       

      IF ATTR([Search By]) = '' THEN RANK(SUM([Product Revenue]))

      ELSE NULL

      END

       

      Any help is appreciated.

       

      Thanks!

       

      Jackie