Top Values

[ashokraju]

Hi,

How to show top 10 values without regarding to its sign.

For Ex: I have 3 values 1000,2000,-3000. So I want to show -3000 as top value irrespective of sign.

[Anil_Babu_Samineni]

Either you can use Fabs() to change sign. Or you may explain how -3000 value will come into Top?

[rahulpawarb]

As a workaround, add an expression in sort by Expression option (Descending):

fabs(Value)

Regards!

Rahul Pawar

[its_anandrjs]

Hi,

First remove -ive sign from value and then find max number with using FABS() function here.

Ex:-

Tab:

Load *,Fabs(Values) as NewVals

Load * Inline

[

Values

1000

2000

-3000

];

Regards

Anand