Skip to Content
0

nested if hana calculation view

Aug 02, 2017 at 12:05 PM

227

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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


df9bi.png (9.9 kB)
Show 1 Share
10 |10000 characters needed characters left 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..

0