ELPROXYCLEANQUANTITIES
Introduced in version: 18.10
Last modified in version : 19.04
Purpose : return a cleaned quantity between a main quantity and a proxy quantity.
Last modified in version : 19.04
Purpose : return a cleaned quantity between a main quantity and a proxy quantity.
Summary
The function ELPROXYCLEANQUANTITIES is a help function, which provides a simplified way to handle quantities. This functions also checks for null or empty strings.
Examples
=ELPROXYCLEANQUANTITIES(A1) or =ELPROXYCLEANQUANTITIES(A1, "")
Returns a verified version of the quantity in A1. If the value referenced in the second parameters is empty or null, this value is discarded.
=ELPROXYCLEANQUANTITIES(A1, B2)
In this case, the function overrides the quantity in A1 and returns a checked version of the quantity in B2. This allows an override of the quantity in A1, for example in the case where a proxy asset is used.
Syntax
ELPROXYCLEANQUANTITIES(quantityMain, quantityOverride)
| Argument name | Description |
|---|---|
| quantityMain | A main quantity. |
| quantityOverride | A replacement quantity. |