SAP HANA Calculation View Column Engine IF-Statement

[former_member683296]

Dear Expters,

i would like to summarize the following script on one key figure. how can i do that? should i user CASE-Statement?

//KeyFigure-1//
if("JAN"=0 , 
if("FEB"=0 , 
if("MAR"=0 ,
if("HUNS">0, 
'T1-2','' ),'' ),''),'')

//KeyFigure-2//
if("JAN"=0 , 
if("FEB"=0 , 
if("MAR"=0 ,
if("AUG"=0 ,
if("HUNS">0, 
'T1-3','' ),'' ),''),''),'')

Thx Alot

[CharlesFeng]

Hi fertem,

Here is the reference about how to use CASE function in calculation view.
https://help.sap.com/docs/SAP_HANA_PLATFORM/e8e6c8142e60469bb401de5fdb6f7c00/35f28ed33bb1447b816e66e...

Best regards,
Charles