Case Statement or Variable logic in Webi report

[Former Member]

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

[Former Member · Accepted solution]

It Should be something like below

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

Regards

Niraj

[Former Member]

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

[Former Member]

Hi Niraj,

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