W<n weekly relational sum of all values less than ('<') on the last day of the specified week (n).
Counts the number of times a true condition occurs (Cx greater than A) during the week and records that value on the last day of the week. The variable must be Conditional (use 'C' instead of 'V'). The week is defined by n, click here for a table defining the weeks.
SYNTAX:
CX W<n A
Where:
CX is a conditional variable reference
n defines the week
A is a numeric constant to compare value against
EXAMPLES:
C22 W<7 10 = 2, calculates the number of times Variable 22 is less than 10 for the week (Sunday thru Saturday, i.e. week type 7) and stores the value on the last day of the week.
NOTES:
This function does not support Expressions. For example (C22 + C21) W<7 10 does NOT work and C22 W<23 (C5+2) does not work.
Function will ONLY work with Daily type variables. Daily Detail variables (i.e. Hourly, 15 Minute) will NOT work with this function.