Skip to Content
0
Nov 24, 2022 at 05:18 PM

SAP HANA Calculation View Column Engine IF-Statement

389 Views

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