Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 16 at 03:31 PM

    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"

    Add comment
    10|10000 characters needed characters exceeded