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

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

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