Calculate the highest value of the specified fields in the retrieved records. You can reuse the result of the calculation in other Actions.
Set Select Record Action, Field to Calculate, Target Field (Optional), and If no records.
Open the list of Actions and select the Action you used to obtain the target records.
Select the field that will be used to calculate the maximum value. This parameter accepts the following field types:
Fields in tables cannot be selected.
The “Calculated” field type must be in numeric format. The “Calculated” field in Date, Time, and Date & time formats is not supported. It supports regular “Date”, “Time”, and “Date and time” field types that are not of the “Calculated” type.
Use this parameter to set the results to another field. You can leave this parameter empty to use the calculation result in another action without setting it to any field.
This parameter accepts the following field types: Fields in tables cannot be selected.
If the field type of the set destination does not match the type of the calculation result, an error will occur at runtime.
Select the action for when there are no records in the result of the “Record Selection Action”. Based on the selection made, the value and result value for the action entered in the “Target Field” when no rows meet the conditions will be as follows:
| Parameter Value | Value to be set in the “Target Field” | Action Result |
|---|---|---|
| Set nothing | Do not change the value of the field | undefined |
| Set blank | Clear the value | undefined |
| Set zero | 0 | 0 |
| Set NaN | NaN | NaN |