MIM WAL and Nested functions

One of the limitations of some of the functions from the MIM WAL is that they only do 2 field comparison. So its

OR: x or y, you can’t say x or y or z

AND: x and y, you can’t say x and y and z

Well, you can, sort of, if you nest the functions.

So in the examples below you would say

OR:

  1. x or y or x = OR(x,OR(y,z))
  2. x or y or z or k = OR(OR(x,y),OR(z,K))

AND

  1. x and y and z = AND(x,AND(y,z))
  2. x and y and z and k = AND(AND(x,y),AND(z,K))