How to filter "-" (minus symbol) from a list box

[rabbani_sk]

Hi Every one,my issue is to hide the "-"(minus symbol)  alone ,but not the data value.

For eg: I have a list box with both negative & Positive data values , my list box will be like this

product    value

a               1

b               -2

c               -3

d               4

e               -5

and my  result should be like below list box,

Product   Value

a               1

b               2

c               3

d               4

e               5

Any Idea??      

[kaushiknsolanki]

Hi,

     Try this.

     Load Product,Fabs(Value) as Value From xyz.

Regards,

Kaushik Solanki

[Gysbert_Wassenaar]

Try as expression: dual(fabs(Value),Value)

[rabbani_sk]

Hi, Kaushik

its working Thanks for Replying....

[rabbani_sk]

Hi Gysbert it's working thanks for Replying....

[nizamsha]

=sum( Replace(value,'-',''))

or

fabs(sum(value))

[brijesh1991]

Hey try this:

Load Product,Fabs(Value) as Value From Table. 

[tajmohamed30]

find it useful after 4 years