Hello everybody, I am trying to apply a calculation based on a value from a column, by example

Ap01:

Item unit Qtyinunit

xxxx TS 2

xxx1 EA 1000

…

The calculation that I need to do is:

if unit = “TS”

then $(Qtyinunit)*1000

else $(Qtyinunit)*1

problem is, that in new column it appears the calculation as string (2*1000) or (1000*1) [not evaluated]

Ap02:

I had done in another way, but takes more transformations:

(column name: Qt01)

if unit = TS

then $(Qtyinunit)

else 0

(column name: Qt02)

if unit not equal TS

then $(Qtyinunit)

else 0

(column name: Qt001

calculate

Qt01 * 1000

(column name: QTF)

calculate

QT001 + Qt02

If the first approach, Ap01, had worked, simplicity was welcomed (I really do not understand why expression was not evaluated…)

Thanks in advance

Miguel