Making Flag based on year

[#1]

Hi there,

I need your help on this.

I want to calculate year on year growth rate so I need to make flags in the data load editor.

How do I create CYTD flag if year is 2015 and create LYTD flag if year is 2014?

Very much appreciate your thoughts.

[Anonymous]

This thread may help:

Year-over-Year Comparisons

[Mark_Little]

Hi,

if you have a year column

IF(year = 2015, 1,0) as CYTD

IF(year = 2014, 1,0) as LYTD

Else if you just have a date column replace year with YEAR(date)

Mark

[jpenuliar]

In script:

YeartoDate(TempDate)*-1 as CurYTDFlag, 
YeartoDate(TempDate,-1)*-1 as LastYTDFlag,