How to implement "if not null then" in webi report (SAP BO 4.2 SP02)

[richard_reeves]

Hello Experts,

Please advice on, How to implement

If parameter a is not null then "parameter is not null" in variable.

For example, In below statement, if the parameter 'Enter 4:' is not null along with these two condition then "G2"

=If ( [Rank] =3 Or [Rank] =4) And ISNULL(UserResponse("Enter 4:")) Then "G2"

Thanks in advance,
R

[former_member198519]

Try a NOT() like this:

=If ( ([Rank] =3 Or [Rank] =4) And ISNULL(UserResponse("Enter 4:")) Then "G2"

elseif(([Rank] =3 Or [Rank] =4) And NOT(ISNULL(UserResponse("Enter 4:")))) then "Enter 4 is not null" else "Default value"

[richard_reeves]

Hello Kuldeep,

In my case if UserResponse("Enter 4:") is not null then G2-- can you please advice.

R

[former_member198519]

You can use the function IsPromptAnswered() to find out if your prompt is null or not.

Try this:

=IsPromptAnswered("Enter 4:") then "promp Answered" else [G2]