Hi All,
i have a requirement where, when the user selects the prompt for fiscal year, for example the user selects 2014, data in the output should be 2014,2013,2012 & 2011. i.e i need previous 3 years data including the year selected.
how will i achieve this ?
Regards
Quote from: Raghuvir on 24 Jul 2015 07:26:10 AM
Hi All,
i have a requirement where, when the user selects the prompt for fiscal year, for example the user selects 2014, data in the output should be 2014,2013,2012 & 2011. i.e i need previous 3 years data including the year selected.
how will i achieve this ?
Regards
Hi All,
used the below condition to achieve this.
[FY_CD]>=?FY?-3 and not([FY_CD]>?FY?)
Regards