Skip to Content

Month and Year Parameter Fields

I'm creating a report with a month range and a year range parameter. The year parameter works fine, but the month range is not pulling the correct data. When I select months 1-5, year 2012-2017, my output is giving me months 1-5 for the selected year range. What I need is data for months 1-2 for years 2012-2016, months 1-5 for only 2017. Can anyone help? Any assistance would be greatly appreciated. Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 08 at 03:36 PM

    Please show your selection formula so we can see how parameters are being used.

    Seems odd you only want months 1-2 for years 2012-2016. Need some logic. What happens when you get to July and want months 1-7 will it still only be 1-2 months for prior years?

    Ian

    Add comment
    10|10000 characters needed characters exceeded