set analysis upper than.

[#1]

Hi,

I try to create a set analysis with a set modifier wheer Num is over than 2000

<Num= {2000}>  it's working

<Num> {2000}> it's not working

someone has got an idea about the syntax?

Eva

[nagaiank]

Try

<Num={">2000"}>

[MayilVahanan]

Hi

     Try this,

          <Num={">2000"}> instead of <Num> {2000}> because in this, <Num> scope finish here itself..

Hope it helps

[#4]

Hi Thanks for yours answer. Is it working withText

[MayilVahanan]

Hi,

     For number only is working . for text also its work like

     <Name = {"m*"}> gives starts with m names like micheal.

Hope it helps

[#6]

ok, Sorry  I tried to simplify it .

I need to do set analysis whn [Fiscal Year Month] sur after [Current Fiscal Year Month]

the format is 2013/004

So I started by a value like :

= sum({<[Fiscal Year-Month] ={">2013/004"}>}metric)

but it's not working neither.

[MayilVahanan]

Hi,

     Check the format once, both are in same format??

     i.e. year/month ?? 2013/004 -> it represents ?

     verify year month and current fiscal year month are in same date format . if not same means, give the same format ..

Hope it helps

[#8]

no it's the same format when I did

= sum({<[Fiscal Year-Month] ={"2013/004"}>}metric)    it's working

= sum({<[Fiscal Year-Month] ={">2013/004"}>}metric)  it's not

thanks for your help

[MayilVahanan]

Hi,

Can you post sample file. Its helps to find it.. Check once, is there value for metric above that 2013/004 ? For my sample, it gives the value correctly..

[#10]

Try Like this ..

Creare one more field with

Fiscal Year- Month  as Num( Fiscal Year- Month )   as  Fiscal Year_MonthNum    in back end ..

and create a variable with num(month ( today())  as Test  and then

= sum({<[Fiscal Year_MonthNum] ={">$(Test)"}>}metric)

Now we are comparing two number fields so this should work.