Difference between revisions of "Absolute Value via Query"

From MidrangeWiki
Jump to: navigation, search
(Query Tip)
 
m
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
[[Categories:Query]]
+
See [[Query]] for links to other tips and techniques we can use in Query.
  
 
Sometimes we may wish to sort values by their absolute value, as opposed to biggest minus at one end and biggest positive at the other end of the report or inquiry.
 
Sometimes we may wish to sort values by their absolute value, as opposed to biggest minus at one end and biggest positive at the other end of the report or inquiry.
Line 8: Line 8:
  
 
In the column descriptions, set the header to *NONE, the width of the field and spacing to 0 (ZERO).
 
In the column descriptions, set the header to *NONE, the width of the field and spacing to 0 (ZERO).
 +
 +
[[Category:Query]]

Latest revision as of 19:56, 21 August 2006

See Query for links to other tips and techniques we can use in Query.

Sometimes we may wish to sort values by their absolute value, as opposed to biggest minus at one end and biggest positive at the other end of the report or inquiry.

Square the field that you want sorted on its absolute value.

You must select this squared result to sort on it, however you probably not want to include it in the report, instead you probably want the original field, which you can print with or without the sign.

In the column descriptions, set the header to *NONE, the width of the field and spacing to 0 (ZERO).