I am trying to do something like this - &=&=(Summary.qty_d)*2

but the formula is not calculating at all?

I am trying to do something like this - &=&=(Summary.qty_d)*2

but the formula is not calculating at all?

Hi,

Well, dynamic formulas does not work in this way, it work in the following way.

e.g (Excel template file can be like)

A B

&=Summary.qty_d &=&=(A{r}*2)

Another example:

e.g

A B

&=Datos.Estado &=&=UPPER(A{r}) --> You may use any Excel Formula in place of "UPPER"

See the topic for reference:

Thank you.