topic Re: Making Flag based on year in App Development

Making Flag based on year

Thu, 12 Nov 2015 14:27:22 GMT

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 — Thu, 12 Nov 2015 15:19:27 GMT

This thread may help:

Mark_Little — Thu, 12 Nov 2015 15:29:00 GMT

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 — Thu, 12 Nov 2015 16:36:24 GMT

In script:

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