Array Variables

When dynamic sub-checklists are used, array variables like LENGTH01 and LENGTH02 are generated. The existing MIN and MAX function can be used with only one parameter so then the whole array of this variable will be analyzed.

Additionally, the following functions are available in the Formula Editor:

SUM(
): Adds the values of all variables of the array
- (SUM(LENGTH) = LENGTH00 + LENGTH01 + ... + LENGTH99)
COUNT(
;
): Counts all variables of the array with the given value
- (COUNT(LENGTH;5) will count the number of all LENGTH elements (LENGTH00, LENGTH01, ...,LENGTH99) which have the value 5)
MIN(
): Determines the lowest value of the array
- MIN(LENGTH) will check all variables like LENGTH00, LENGTH01, LENGTH02, ... , LENGTH99 to find the lowest value
MAX(
): Determines the highest value of the array
- MAX(LENGTH) will check all variables like LENGTH00, LENGTH01, LENGTH02, ... , LENGTH99 to find the highest value

Example

In the following video, a checklist template has been set up with a sub-checklist for measurements that includes lines to calculate the sum of measurements for all variables (length, width, and height), will display the lowest and highest Length values, and will then count how many times there is a Length value of 4.

A test checklist is created to simulate the Document Checklist, two sub-checklists are created and values are entered for each. Then the Recalculate action is run to calculate the array values in the lines. The first line shows the cubic meter of 216, which is 6 * 6 * 6, based on the measurement values. The next lines show that the lowest Length value was 2 and the highest value was 4. The last line shows that there was one instance of a Length value of 4.

Array Variables

See Also