Last Year Data

[krunal]

Hi

I have fiscal year as
2014-2015
2015-2016
2016-2017
2017-2018

I have prompt for fiscal year,

now my requirement is if user select 2016-2017 I want to show the full last year data(i.e 2015-2016)
what will be the condition I have to write

Thanks in advance
Krunal

[BigChris]

Are your Fiscal Years static choices, or are they based on a selection from your data?

[krunal]

static choices

[BigChris]

Code Select Expand

[YourTranscationDate] between _make_timestamp(
(case ?YourPrompt?
  when '2014-2015' then 2013
  when '2015-2016' then 2014
  when '2016-2017' then 2015
  when '2017-2018' then 2016
    else 1999
  END),1,1)
and  _make_timestamp(
(case ?YourPrompt?
  when '2014-2015' then 2013
  when '2015-2016' then 2014
  when '2016-2017' then 2015
  when '2017-2018' then 2016
    else 1999
END),12,31)
or something like that anyway  :D