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.