Formula with smart marker not working?

Tbaseflug · December 16, 2011, 8:37am

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

but the formula is not calculating at all?

amjad.sahi · December 16, 2011, 11:34am

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.