Series Functions

Prev Next

Introduction

This section covers all functions which can process value series of variable sizes.


Procedures and Functions Provided:


Arithmetic and Boolean Series Functions, Two parameter passing methods for series functions:
    add
    and
    div
    mul
    or
    sub
    xnor
    xor

min and max functions:
    max
    max ignore blanks
    max ignore zero
    max ignore zero
    min
    min ignore blanks

Vectorizable min and max functions:
    vmax
    vmax 123
    vmax abc
    vmax abc ignore case
    vmax numeral
    vmax string
    vmax string ignore case
    vmin
    vmin 123
    vmin abc
    vmin abc ignore case
    vmin numeral
    vmin string
    vmin string ignore case

min and max functions on strings:
    max abc
    max abc ignore case
    max string
    max string ignore case
    min abc
    min abc ignore blanks
    min abc ignore both
    min abc ignore case
    min string
    min string ignore blanks
    min string ignore both
    min string ignore case

min and max functions on numerals:
    max 123
    max 124 ignore zero
    max numeral
    max numeral ignore zero
    min 123
    min 123 ignore zero
    min numeral
    min numeral ignore zero

Limit values within lower and upper boundaries:
    limit

count functions:
    count
    count ignore blanks
    count ignore both
    count ignore zero