Skip to Content
avatar image
Former Member

nested if hana calculation view

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 03, 2017 at 07:39 PM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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..