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 (21000) or (10001) [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