Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formulae: MAX ABS UNIQUE VALUE? - Visokio Forums
Formulae: MAX ABS UNIQUE VALUE?
  • lowellchung August 28, 2013 12:01PM
    Hi - Is there a way with 2.8 I can take a range of -/+ numbers, find the absolute max and flag that number.

    If there is more than one instance of the max number, I just want to be able to take/flag one of then not both.

    Cheers, Lowell
  • 2 Comments
  •        daniel August 28, 2013 6:07PM
    You should be able to combine the functions

    ABS( ) with

    Subset_max( ) or max( )

    Depends on if you want the max number out of a field or not.

    Omniscope Hobbyist:
    - https://www.linkedin.com/in/dancklam
    - http://spatiametrics.wordpress.com/omniscope-data-visualisations
  •     paola August 29, 2013 10:35AM
    It might be easier to do it in two steps, first to add a column to convert all numbers to ABS() value, then add the Max flag field:

    IF([AbsValue]=(SUBSET_MAX([AbsValue])),
    "this is Max",
    null)
Add a Comment

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

Tagged