Doubt on Not Assigned

[Former Member]

Hi Experts,

Recently i designed a webi report. In that report i am getting data like this.

I want to replace Not assigned as NA. Please suggest me how to do that.

Thanks,

Sravani.N

[Former Member · Accepted solution]

You can use an IF statement in every column to replace the result

for eg If([Dimenison1]="Not Assigned") then "NA" else [Dimension1].

similarly use this for every dimension in the table columns

[Former Member · Accepted solution]

Hello Manish,

Here my source is BEX. where i need to apply the formula. In BEX or WEBI.

Thanks,

Sravani.N

[Former Member · Accepted solution]

Webi

[Former Member · Accepted solution]

In Webi where you have dragged your dimension over there replace with this formula alongwith ur dimension name