4 Replies Latest reply: Aug 2, 2018 11:01 PM by Peter Watt RSS

    Challenge with Date Range in Set Analysis

    Peter Watt

      I've been trying all day to implement what I thought would be a simple date range in a set analysis example. I have a data island for Date selection. The selection will be used to summarize the previous 90 days of sales.


      Example (not working):


      sum({$<[_Date]={">=($(=SelectDate)-90) <=$(=SelectDate)"} >} NetSales)


      I have been able to get it working by hard-coding the lower value:


      sum({$<[_Date]={">=04/01/2018 <=$(=SelectDate)"} >} NetSales)


      I'm sure my problem is simple and I'm not seeing it. Appreciate the assistance.