GetValueByDate(Input: Variant, Date: Variant)
Input. The series, which value should be obtained.
Date. The date, for which the value should be obtained.
It returns series value to the specified date.
As the value of the Value parameter constant, parameter or object of the TimeSeries type can be sent and as the value of the Date parameter - number, string or parameter.
Formula | Result | Application |
= GetValueByDate({GDP|Anchorage[t]}, 2005)*2 | Value of the GDP|Anchorage series for 2005 will be multiplied by two. |
It can be used in formulas of calculated series of time series database and in formulas of attribute-based models of modeling container. |
= GetValueByDate(X1, "2015A")*2 | Value of the X1 factor for 2015 will be multiplied by two. |
It can be used in model variable-based formulas of modeling container. |
See also:
Functions Available in Expression Editor │ Other Functions │ IModelling.GetValueByDate