Year to date in List box

[#1]

Hi

I have year to date filed in list box with two values -1 and 0 where upon selction of -1 gives me YTD data. I want to display only YTD(-1)  value in list box and want  to hide the value '0'. Please find attached screenshot

look like something wrong with my script

=if(D_Date.Flag_Curr_YTD='-1', 'YTD', D_Date.Flag_Curr_YTD)  

[mphekin12]

Try this for your expression:

=if(D_Date.Flag_Curr_YTD='-1', 'YTD', Null())

[#3]

Hi mphekin12,

Its not working out. Should i specifiy null in a statement ?

[mphekin12 · Accepted solution]

I'm sorry I forgot the () for the Null function.  Try this:

=if(D_Date.Flag_Curr_YTD='-1', 'YTD', Null())