Skip to Content
0
May 28, 2018 at 11:30 AM

filtering on variable - webi report

107 Views

Hi all ,

I created a variable on webi report called Rnc_Degraded:(also file attached)

=If (100*([PMNOSYSTEMRABRELEASESPEECH]/([PMNOSYSTEMRABRELEASESPEECH]+[PMNONORMALRABRELEASESPEECH])) >= 1.5*RelativeValue(RunningAverage(100*([PMNOSYSTEMRABRELEASESPEECH]/([PMNOSYSTEMRABRELEASESPEECH]+[PMNONORMALRABRELEASESPEECH]));([RNC]));([Daily]);-1)
Or [PMNOSYSTEMRABRELEASESPEECH] >= 1.2*RunningAverage([PMNOSYSTEMRABRELEASESPEECH];([RNC])))
Then (100*([PMNOSYSTEMRABRELEASESPEECH]/([PMNOSYSTEMRABRELEASESPEECH]+[PMNONORMALRABRELEASESPEECH])) /  RelativeValue(RunningAverage(100*([PMNOSYSTEMRABRELEASESPEECH]/([PMNOSYSTEMRABRELEASESPEECH]+[PMNONORMALRABRELEASESPEECH]));([RNC]));([Daily]);-1))
Else 0

after running the report the variable gets values of number when there is a degradation

or 0 when there is no degradation.

I tried to do filtering of Rnc Degarded >0 on the variable but it changes the table's values.

I attached files of before and after filtering

how can I do a the filtering without changing the table's values?

thanks