how to show a staright table expression in a list box

[#1]

Hi all,

I have a straight table with 4 expressions and 3 dimensions and one of the expression (variance) having positive and negative values ,

my requirements is I need to create a list box as filter its should show 'positive' n 'negative' if user selects negative, only negative values should display in straight table and vice versa..

Thanks in advance

santhosh

[Anonymous]

Hi Venkat

did u have a look at the test file i sent u i had it working

[#3]

can you send me the attachment to venkata.terli@birlasoft.com

[Anonymous]

i have emailed tou ur email u specified

[sunilkumarqv]

@Hi Venkat,

you can create one flag  field which is what like for to identify the values positive or negative

so please kindly check and let me know so that we can find alternative

[Anonymous]

Hi Sunil i saw ur script but now lets bear in mind that the column is a calculated expression

have a look at the test app i sent

[#7]

Hi farai huruba,

Thanks for you test file

its helpful but my scenario is I have a straight table with 5 dimensions and four expressions , and the third expression =( Exp1-Exp2) this  expression is giving all the positive and negative values,

now can filter those positive or negative values by using a list box...?

Venkat.

[sunilkumarqv]

hi farai, i seen your expression that's good idea but even same  Avinash r commented before, so i came with new idea.

[#9]

Hi sunil,,

what is that idea are you gng to share anything.

venakt

[sunilkumarqv]

yaa i shared the attached file before look into that.

[Anonymous]

Yes u can creat another calculated using this

if( Exp1-Exp2) <0,'-','+')

this  will have a column with either "-" or "+"

then create a list box and use  the expression