
Breaking a formula to create expression
Lucian Cotea Dec 19, 2011 11:25 AM (in response to dgonzalez )Use EVALUATE() function

Breaking a formula to create expression
dgonzalez Dec 20, 2011 3:14 AM (in response to Lucian Cotea)This option is valid because I need to do the calculation in the expression and not in the scrip. Anyway is there any equivalent function EVALUATE for incorporation into an expression or is there another solution
.

Breaking a formula to create expression
Lucian Cotea Dec 20, 2011 3:36 AM (in response to dgonzalez )You can use $() function to evaluate an expression, but you must give it an expression to evaluate, not a table of expressions.
You need in fact first to do an aggregation of Amount column by Field 2 of the second table (which btw should be not named like that because it will do a join with Field 2 from the first table), then apply the formula.
You have to rethink your approach.

Re: Breaking a formula to create expression
dgonzalez Dec 20, 2011 4:11 AM (in response to Lucian Cotea)I cannot find the way to go. Now I'm looking to see if breaking the formula with something but do not see it either.

Prueba2.qvw 158.2 K

Breaking a formula to create expression
dgonzalez Dec 20, 2011 12:40 PM (in response to dgonzalez )Can you make a call to a macro to do the calculation from an expression of a pivot table? This being so, how would you do?



