If Expression - Help

[suvechha_b]

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 .

Thanks

[Saravanan_Desingh]

Are you trying to use different Fieldnames here?

=If(IsNULL([Risk Model End Execution Id]),fieldname1,fieldname2)

I don't think this will work. Please show some example of how you want. 

[suvechha_b]

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

Regards

[Saravanan_Desingh]

This is a valid Expression in Dimension.

=if(IsNULL([Risk Model End Execution Id]),'NULL','NOTNULL')

This should work. Are you getting error?

[suvechha_b]

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 ?

[Anil_Babu_Samineni]

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)