IF() with ISNULL()

I want to calculate a dimension, it consists of stacked IF-clauses where the last should be

IF(ISNULL([d/"A_VQMNCRCO01_NCR_P_1":Cause_Group_3a1r1601l4]) ,'Not assigned' ))))))))))))))))

This doesnt give the result 'Not assigned' but '(Null)'. Do I need to add something like =TRUE? This I tried but doesnt change the result.

My second question how can I use Not in 'Not assigned' so that it is not used for the function NOT() in capital letters?


Best Answer


Sign In or Register to comment.