Hi Team,
I am using an expression, i.e. - if(comparison_type = 'MTD', date(MonthEnd(Date#([time] & '-' & right(years,4),'MMM-YYYY')),'MMM-YYYY'), if(comparison_type = 'YTD' OR comparison_type = 'Year on Year', right(years,4),
//else QTD
IF(time = 'JAN' OR time = 'FEB' OR time = 'MAR', Right(years, 4) & ' Q1' ,
IF (time = 'APR' OR time = 'MAY' OR time = 'JUN', Right(years, 4) & ' Q2',
IF (time = 'JUL' OR time = 'AUG' OR time = 'SEP', Right(years, 4) & ' Q3',
Right(years, 4) & ' Q4')))))
Output is : Jan-2018, Feb-2018....2017 Q1, 2017 Q2... 2017, 2018 Etc....
When I am creating a Variable --> vTime and assigning the same expression and calling the same variable in listbox with the $(vTime). It is not working.
Can anyone suggest how it will work with the variable in Listbox.
Regards,
AK
