Skip to Content
0
Sep 11, 2018 at 04:20 PM

IF THEN ELSE STATEMENT IN Calculated Column HANA

22095 Views

Hi Experts,

I have a requirement to fill one column with a 3 digit code based on few conditions.

I am trying if then else statement/case in calculated column in graphical view. I searched in the forum but I am not able to identify the right thread which solves my problem.

I have these date columns in my project node - 0POS_DATE , 0PSTNG_DATE, 0DUEDATE

based on the fileds following is the logic I am trying to implement. Please guide me.

CASE

When "0POS_DATE" <> '00000000' Then '231'

When "0PSTNG_DATE" = '00000000' OR TO_DATE ('2018-09-01') < "0PSTNG_DATE" Then '723'

When "0DUEDATE"='00000000' OR TO_DATE ('2018-09-01') <= "0DUEDATE" Then '654'

When DAYS_BETWEEN("0DUEDATE" , TO_DATE (2018-09-01')) > 100 Then '211'

ENDCASE.