Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to display last two years data based on selection: I am using
concat({<OpYear={">=$(vTwoyear)<=$(vCurrentYear)"}>} OpYear,'"|"')
But it gives me only 2014|2014|2014|2014 lot of times, Any solution for this?
Have a look at this
concat(DISTINCT {<OpYear={">=$(vTwoyear)<=$(vCurrentYear)"}>} OpYear,'"|"')
Try like:
concat({<OpYear={">=$(vTwoyear)<=$(vCurrentYear)"}>} Distinct OpYear,'"|"')