3 Replies Latest reply on Oct 1, 2018 1:19 PM by malvika.tripathi.0

    Year-to-Month Calculation using parameters


      I want to dynamically update a report on a year-to-month basis with the year/month parameter. Suppose I select "201707" (07 being July) from the parameter control, sales and profit data (or more measures, if required) should be displayed from Jan 2017 till Jul 31, 2017. We tried the calculation below but could not figure out how to make it work for multiple measures.


      IIF(Order Date >= DATE("1/1/" + LEFT([ReportYrMo],4)) //1/1/2017

          AND [Order Date] <= DATE(RIGHT([ReportYrMo],2) + "/1/" + LEFT([ReportYrMo],4)) //8/1/2017

          , [Sales], 0)


      Workbook is in 10.5v. Any help will be appreciated. Thanks in advance!