Skip to Content
0

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

Jan 15 at 09:07 AM

42

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

seshu P Jan 15 at 09:49 AM
0

We have to create multiple variables for the same ..

Share
10 |10000 characters needed characters left characters exceeded