| Use: | Displays the maximum value of a numeric field for the currently selected practice and patient. You can use this function with the following template types: Medical Records, Medical Records Popup, Medical Records Extended Popup, Demographics Extended Popup. |
| Syntax: | {MAX( «field» )}
|
| Arguments: |
«field»
table_name.field_name (no braces)
|
| Returns: | The maximum numeric value |
| Example 1: |
Field = medical_record_template_.txt_mrt_numeric_field
Five encounters (5, 45, 32, 121, 99)
{MAX( medical_record_template_.txt_mrt_numeric_field )}
Result: 121 |
| Example 2: |
Field = medical_record_popup_.txt_mrpu_numeric_field
Three encounters (13, 84, 62)
{MAX( medical_record_popup_.txt_mrpu_numeric_field )}
Result: 84 |
| Example 3: |
Field = medical_record_ext_popup_.txt_mrepu_numeric_field
Two encounters, three records per encounter
(324, 356, 213, 278, 410, 156)
{MAX( medical_record_ext_popup_.txt_mrepu_numeric_field )}
Result: 410 |
| Example 4: |
Field = demographic_ext_popup_.txt_depu_numeric_field
One encounter, four records (3, 6, 12, 8))
{MAX( demographic_ext_popup_.txt_depu_numeric_field )}
Result: 12 |
