Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Either you can use Fabs() to change sign. Or you may explain how -3000 value will come into Top?
As a workaround, add an expression in sort by Expression option (Descending):
fabs(Value)
Regards!
Rahul Pawar
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