Skip to Content

Case Statement or Variable logic in Webi report

Hi,

I need to show the values for one column in webi report like if the document ID has value then "Document" and if it is null then " Batch"

Can any one provide me logic for this.

Regards,

Ravi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 19, 2017 at 06:52 AM

    It Should be something like below

    = If Not(IsNull(document ID)) Then "Document" Else "Batch"

    Regards

    Niraj

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 19, 2017 at 07:32 AM

    Hi Niraj,

    Thanks for the logic....It works perfectly.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 19, 2017 at 08:36 AM

    Glad it worked for you please close the thread by marking the answer as correct

    Add comment
    10|10000 characters needed characters exceeded