cancel
Showing results for 
Search instead for 
Did you mean: 

How to add Input Control's Selection value to Report

former_member194503
Participant
0 Kudos

Hi Friends,

I am using 4 Combo boxes in  input control of a webi report. How do I add the Input Control's Selection value to Report ?

For an Example My First Combo box is Country. I have used in a blank cell the below given syntax but what happen when there is a value contain 0 ?

I used

=If (Count([Country])) >1 Then "All" Else [Country]

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Please use below code;

=If Pos(ReportFilterSummary();"No Filter")<>0 Then "All" Else [Country]

Regards

Niraj

former_member198519
Active Contributor
0 Kudos

This might help: