Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
Hi,
Try this.
Load Product,Fabs(Value) as Value From xyz.
Regards,
Kaushik Solanki
Try as expression: dual(fabs(Value),Value)
Hi, Kaushik
its working Thanks for Replying....
Hi Gysbert it's working thanks for Replying....
=sum( Replace(value,'-',''))
or
fabs(sum(value))
Hey try this:
Load Product,Fabs(Value) as Value From Table.
find it useful after 4 years