nested if hana calculation view

[Former Member]

Hello gurus

i am facing difficulty in defining nested if statement in the calculated column.

I have something like below in the calculated column:

if("MARG_VIEW"!='Z', "MARG_VIEW",

if("YMQTYPY"=0 and "YMQTYAY"!=0,'41',

if("YMQTYAY"=0 and "YMQTYPY"!=0,'42',

if("YMQTYAY"=0 and "YMQTYPY"=0,'43','N'))))

if the first line of code is satisfied, it gives me correct result else

this is giving me NULL values for the rest lines of my code.

I don't understand why an if statement doesn't work when comparing with key figures..

Any pointers? Thanks.

[jeetendra_kapas · Accepted solution]

Your IF cond is fine. Possibly this calculated column you created is on right join node or From where data is coming as null

[Former Member · Accepted solution]

thanks Jeetendra for your input..unfortunately..NULL handling was not done properly for some calculated measures in the previous views. We could sort it out later..