6 Replies Latest reply on May 16, 2013 3:45 PM by Shawn Wallwork

    Custom date ranges using Parameter Controls

    Narciso Aguda

      I am trying to create a Parameter Control that will filter the worksheet for a custom date range based on a Display Name.

       

      Created a Parameter with these settings:

      MarkingPeriod.PNG

      Then I created a Calculated field:

      calc_field_selector.PNG

      But keep getting the "Cannot use 'boolean' type in 'case' expression" error.

       

      Is there a better way to do this? I've attached a sample Packaged Workbook