Filter Selection

[#1]

Hello,

I have a set of reason code used as a filter.

Reason_Code

     'Blank'

     '01'

     '02'

     '03'

     '04'

     '05'

I have to include this 'Blank' code along with any other reason codes every time when I change the selection in order to make a percentage calculation meaningful. Are there anyways to fix that 'Blank' selection? Or, do I have to create a calculated field to do this?

Your help is much appreciated. Thanks.

[senpradip007]

Hi Lin.

Do you mean that when you select 03 or 04 it is autometically select 'Blank' also?

If it is so try this

=Sum({<Reason_Code = Reason_Code + ({'Blank'}) >} Value)

regards.

PS

[sujeetsingh]

Lin i do not get it .

Can you post a sample

[#4]

Two way to solve it out

1- simple use suppress null values in dimensions.

2- suppress on scrip level use this query

use where condition

where Reason_Code <> '  ' or Reason_Code <> 'Blank' ;

[#5]

You can make it possible using trigger on the field.

GO to Setttings-> Document Properties-> Triggers-> Field Event Triggers

Add "OnSelect" trigger on the field Reason_Code, then

Then "Select in Field"

Field as Reason_Code

SearchString as

='('&concat(Reason_Code,'|')& '|' &'Blank' &')'

Thanks,

Angad