WY>n weekly relational sum of all values greater than ('>') specified constant 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. This function does not cross calendar year boundaries even though the defined week might.
SYNTAX:
CX WY>n A
Where:
CX is a conditional variable reference
n defines the week
A is a numeric constant to compare value against
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.
EXAMPLES:
C22 WY>7 10 = 2, calculates the number of times Variable 22 is greater than 10 for the week (Sunday thru Saturday, i.e. week type 7) and stores the value on the last day of the week.
C1 WY>7 10