Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can call the variable in the filter pane
Please find the attached JPG. It's not coming.
Regards,
AK
I did it, But not working.
Regards,
AK