cancel
Showing results for 
Search instead for 
Did you mean: 

How to replace "Not assigned" or "#####" values with blank in Web I reports?

Former Member
0 Kudos

How to replace "Not assigned" or "#####" values with blank in Web I reports?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Use the below Formula in the Alerter : if ([object] =("Not Assigned" or "#######") ;"";[object])

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

I did selected the cloumn and wrote the formula,but  it affects other columns also..

Thanks

Former Member
0 Kudos

Hi,

where did you write the formula?

first select the column(Particular object) then go to new rule.

then follow this steps .

after this it will work perfectly,l

Former Member
0 Kudos

Hi,

I followed the guidelines as u have mentioned,but its not working and i am getting error.The error msg is

"

Unable to get the first page of the current report.

Please check the validity of your report or contact your administrator. (ERR WIJ 20003)."

If i close dat popup window,agin another popup rises,it says

"

The report cannot be generated.

Please contact your administrator."

I dont know wats causing this problem..

antonette_oberholster
Active Contributor
0 Kudos

Hallo

Did you find a solution?

Antonette

Former Member
0 Kudos

Hi,

We are generating reports on top of the BEx query and I cant see any alerter symbol in the reports.

Thanks,

Vignesh

oliver_uy2
Active Participant
0 Kudos

try creating the formula in Webi Report not bex.

Former Member
0 Kudos

Alerters are called now "conditional formatting":

Use rich internet application (or rich client) version for this (right click on the report, modify).

TammyPowlas
Active Contributor
0 Kudos

Hello,

This question belongs in the Web Intelligence space

I am moving this question there now

Please post these types of questions there in the future.

Thanks

Tammy

Former Member
0 Kudos

Hi,

You can use Alerters for this..if(Not assigned) Or (####) then "" else [object]

Thanks,

Alifia-