list box value in current selection

[Anonymous]

Hello everyone,

I have created one list box and current selection. If i select year value in list box that value is not displaying properly in current selection.

It is displaying no of days in that particular year. But I want to display as year value.

In script to get year value I used like this

if(year([DW Load])>=2014,[DW Load]) as listbox

in list box i used year(listbox)

Regards,

Kumar

[vishsaggi]

Great it worked for you. There i have just used a preceding load before the actual transformation happened in the actual load. Then used the Year function as you know it.

V.