FTMV returns values from a 15 minute variable. NOTE: This function has been replaced by DDV and is only documented here for older reports that may still use the FTMV function.
SYNTAX:
FTMV(VarNum,Offset/Date, MarkViol, ViolBoldFlag, ViolForeColor,ViolBackColor)
VarNum: The variable number to get the value for.
Offset/Date:If the field is numeric it is assumed to be the offset and is defined as the offset (number of slots for the variable type) from the start date of the report. For example, if the start date is 1/1/2000 and the offset is 2 the value for the 2nd data slot will be returned. I.E. for a 15 minute variable the value for the 12:15 AM to 12:30AM slot will be returned. If the field is a date/time in quotes or a cell reference to a cell containing a date/time the value for the slot specified by the date/time will be returned.
MarkViol: Set to 1 to mark violations (based on variables limits) if they occur. How they are marked depends on the next settings.
ViolBoldFlag: Set to 1 to bold violations.
ViolForeColor: Sets the foreground color of cells that contain violations. Number represents a RGB color code (0 to 16,777,215).
ViolBackColor: Sets the background color of cells that contain violations.
NOTES:
WARNING: Function is still supported but has been replaced by DDV. Support for this function may be ended. Use at your own risk.