Comments (...)

Revision history:

Introduced in QPR 7.2.1

 

Sets formula for the specified element and series. Changes input type of this series to "Formula". All periods of the element are calculated.

 

Synopsis:

 

SCModel.SetFormula(ElementId, SeriesSymbol, Formula)

 

Parameters:

 

ElementId: Integer

SeriesSymbol: String. Must be symbol of some series that belongs to ElementId

Formula: String. Formula string like "AVERAGE(?.ACT())"

 

Required Rights:

 

Administrator or Model Administrator rights to the SCModel.

 

Return Values:

Below are listed the return values that this function can return:

 

RV_SUCCESS

RV_MODEL_NOT_OPEN

RV_NO_RIGHTS

RV_ELEMENT_NOT_FOUND

RV_CANNOT_SET_INPUT_TYPE

RV_LOOP_IN_FORMULA

RV_OBJECT_IS_LOCKED

RV_UNKNOWN_ERROR

 

Example Procedure:

 

iRet = oModel.SetFormula(ElementId, "ACT", "1") 'set value 1 to all periods

 

Comments (...)