Skip to Content

Replace null values of webi report as " Not assigned" in all the columns of cross tab

Hi ,

Please let me know how to replace Null values of all dimensions in webi report to "Not Assigned" in single go.I have multiple columns which has null values'

i can put formula below way if it a single column .

=If( IsNull([Candidadte ID]);"Not assigned";[Candidadte ID])

I have multiple columns which should show as "Not assigned " In null values.

Please help.

Regards,

Naiduz

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 15 at 09:49 AM

    We have to create multiple variables for the same ..

    Add comment
    10|10000 characters needed characters exceeded