How to make My Box 2 Display YrMthWk ?

[paulyeo11]

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

[MarcoWedel]

Hi,

maybe this is what you need?

hope this helps

regards

Marco

[paulyeo11]

Hi Marco

Thank you for your sharing . May be my explaination is not clear , that is why so many people cannot understand.  I hope below image can make all understand.