Exclude G/L with UserResponse in Webi report

Question

I am using Business Objects WEBi to build a new report.

In a cell I want to show the UserResponse to the G/Ls that have been excluded in a list, but when I use the formula =UserResponse["G/Ls to Exclude:"] I get a blank cell

How do I get around this issue?

score 1 · Answer 1 · answered Jul 05 '17 at 04:42

1

Check whether the string has any blank spaces trailing at the back or front of the string . This may sometime does not bring the value available in the user response.

answered Jul 05 '17 at 04:42

Riya

21
5

score 0 · Answer 2 · edited May 07 '20 at 00:38

0

Check whether the "G/Ls to Exclude:" is holding the exact string what you have give in the prompt display.

edited May 07 '20 at 00:38

lordhog

3,427
5
32
43

answered Oct 21 '16 at 08:12

Riya

21
5

score 0 · Answer 3 · edited Aug 18 '17 at 23:24

0

Can you try without double quotes?

=UserResponse[G/Ls to Exclude:]

edited Aug 18 '17 at 23:24

Joe Mayo

7,501
7
41
60

answered Aug 18 '17 at 23:05

karthik Gandhi

9
1

Exclude G/L with UserResponse in Webi report

3 Answers3