Home : M<
Q13316 - INFO: M<

M< monthly relational sum of all values less than ('<') a user defined constant on the last day of month.

Counts the number of times a true condition occurs (Cx less than A) during the month and records that value on the last day of the month.  The variable must be Conditional (use 'C' instead of 'V')

SYNTAX:

CX M< A

Where:
CX is a conditional variable reference
A is a numeric constant to compare value against

EXAMPLES:

C22 M< 10 = 8, calculates the number of times Variable 22 is less than 10 for the current month and stores the value on the last day of the month.

NOTES:

This function does not support Expressions.  For example (C22 + C21) M< 10 does NOT work and C22 M> (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.

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/24/2011 2:44 PM.
Last Modified on 12/19/2019 2:54 PM.
Last Modified by Scott Dorner.
Article has been viewed 2666 times.
Rated 6 out of 10 based on 2 votes.
Print Article
Email Article