Error in Report

building reports webintelligence
1

I have variables Revenue (measure), order number

I have created a new variable (measure) using the above variable and named it as SUM

formula : =sum([revenue]) in ([order number])

and again created new variable (dimension) and named it as IMPORTANCE

formula : =if[SUM] < 15000 then “a” else “b”

Iam getting the correct result for this variable IMPORTANCE but when i am trying to filter it, it showing only “b” vale in the selection…please help me

creatme4u (BOB member since 2012-08-28)

2

Welcome to B:mrgreen:B!
You can apply block filter and can enter a as constant.

Thanks,
Zaif

zaif235 :us: (BOB member since 2010-06-15)