2 Replies Latest reply: Jul 17, 2013 3:16 AM by Darrin Pilkington RSS

    Trying to exclude all values in set analysis but one list box

    Darrin Pilkington

      I have a dashboard that I have as an overview of all records for yesterday and the last seven days with the Identifier = 1 to disregard all selections.

       

      What I need is to disregard all selection except one.  Dept

       

      Is there something I can add to the formula below to pull in the list box for Dept only?

       

      Formula for example:

      count( {1 <DaySerial = {'$(vYesterday)'}>} JournalID)

       

      Thanks for the help.