11 Replies Latest reply: Sep 17, 2015 9:13 PM by PAUL YEO RSS

    How to make My Box 2 Display YrMthWk ?

    PAUL YEO

      Hi All

       

       

      I have and field name = Data Type at Box 1 :-

       

       

      LOAD * INLINE [

      Date Type, Column2

      year,year

      yr_jp,yr_jp

      YrWk,YearWeek

      YearQtr,YearQtr

      YearHalf,YearHalf

      Yr_Qtr_jp,Yr_Qtr_jp

      YrMth,YearMonth

      YrMthWk,YearMonthWeek

        ];

       

      I have a Box 2 with below expression :-

       

       

      =IF([Date Type]='year','Year',

      IF([Date Type]='Yr','year',

      IF([Date Type]='YrMth','Yr Mth',

      IF([Date Type]='YearMonthWeek','YrMthWk',

      IF([Date Type]='YearQtr','Yr Qtr'

      )))))

       

       

      My Question is why Box 2 not display YrMthWk ?

       

       

      Paul