Hi All ,
I am struggling with the below expression -
=if(IsNULL([Risk Model End Execution Id]),fieldname,fieldname)
I want use this as a dimension of a straight table .
Yes Saran, you are correct . I want the below expression which you mentioned.
=If(IsNull([[Risk Model End Execution Id]]),fieldname1,fieldname2)
My requirement -
I need to show report of NULL [Risk Model End Execution Id] thus I create a Master Dimension -
Test1 = =if(IsNULL([Risk Model End Execution Id]),'NULL','NOTNULL')
which gives me to select "NULL" or "NOTNULL" .
Is there any way I can use the condition in the dimension of straight table , when applicable will give a only "NULL" value report. ?
It is giving correct result, but I only want to show the NULL. But you can see the screen below, I am getting both NULL and NOTNULL. How to only show NULL ?
For me that is quite ok only, What are you getting as output? try this
=if(Len([Risk Model End Execution Id])=0,fieldname,fieldname)