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. |