1 Reply Latest reply on Jun 7, 2018 5:58 PM by Shinichiro Murakami

    Filtering a measure value by Start and End date

    Aaron Duncan

      Hey guys,


      So i am working on a contract budget report and i need to be able to filter the sum of distributions(measure) by the contracted START and END dates. However there are some caveats;


      distributions = ORA data source

      issue date (dates that are contributed to distributions) = ORA data source

      start and end date = excel template


      At first i wanted to do something like;


      IF issue_date BETWEEN (start_date, end_date)

      THEN sum(distributions)


      BUT i want to do something like


      SUM (distributions) for all issue_dates BETWEEN(start_date, end_date)


      data is confidential, however i can try to mock something up if needed.