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.
This thread may help:
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)
YeartoDate(TempDate)*-1 as CurYTDFlag, YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
Retrieving data ...