Misc Functions

LHS()

Returns the object on the left side of the = sign.

Example

LHS().ProductID returns the product id of the object on the left side of the = sign of the row currently being evaluated.

Example

The following example shows how to calculate the Amount by multiplying the Quantity by Price specified in a different spreadsheet, matching by ProductID.

@Amount[]= @Qty[] * @Price list!Price[ProductID == LHS().ProductID]

LHSVALUE(prop name)

Returns the value of the specified property of the object on the left side of the = sign

Example

LHSVALUE(AccountID) returns the account id of the object on the left side of the = sign of the row currencly being evaluated.

tmpl_foreach_operand(formula, operand template :string)

Accepts a formula expression and an operand template, and returns an AST representing a valid spreadsheet formula. The AST can be evaluated by the EVAL function and returns a value.

The #LHSCOL template token is replaced by the name of the column on the left hand side of the expression.
The #OP template token is replaced by the current operand token from the formula parameter.

Example

Formula = "L01 + L02" and left hand side column name is "Total", Given the expression:

tmpl_foreach_operand(Formula, "#LHSCOL[LineID == \"#OP\"]")

will return an AST equal to the AST of this formula:

@Total[] = @Total[LineID == "L01"] + @Total[LineID == "L02"] 

Example

Formula = "L01 + L02":

@Total[LineID == "L03"] =EVAL(tmpl_foreach_operand(Formula, "#LHSCOL[LineID ==\"#OP\"]"));

Will be translated into an AST and executed like a formula equivalent to:

@Total[LineID == "L03"] = @Total[LineID == "L01"] + @Total[LineID == "L02"];