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