Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
This thread may help:
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
In script:
YeartoDate(TempDate)*-1 as CurYTDFlag,
YeartoDate(TempDate,-1)*-1 as LastYTDFlag,